I am trying to process a field that is defined as a Text field in sql server - Data flow task receives this error below. I tried to modify the data conversion of this field to a Text Stream field but that didn't work. Data Conversion [456]] Error: Data conversion failed while converting column "Comments" (786) to column "Copy of Comments" (847). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". How can I get this field from my input source to my database source?