Truncation error when Copying Columns in SSIS (1 Viewer)

gavinjb

Registered User.
Local time
Today, 15:35
Joined
Mar 23, 2006
Messages
39
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,
 

Users who are viewing this thread

Top Bottom