View Full Version : Truncation error when Copying Columns in SSIS


gavinjb
11-21-2006, 02:18 AM
Hi,

I have a SSIS Package which transfers data from one database to another and then does some conversino work on the data. Only problem is that when I run this script I get the following error message.

[OLE DB Source [1]] Error: There was an error with output column "StarHashOther" (83) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

Does anone know what could cause this, I have checked and the field on both source and destination are of the same type and size varchar(2)

Thanks,