I have a Package running on a server - SQL Server 2005 - 9.0.3042
DFT - Source SQL server 2000 8.0.2040 to Destination SQL Server 2005 9.0.3042
My workstation has sql 2005 client tools installed.
The package fails with the below message when the agent job runs nightly.
The same package when exported and run from my workstation completes successfully.
OnError, computer,operator,source,sourceid,executionid,starttime,endtime,-1071607780,0x,There was an error with output column "col1" (125) 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.".
OnError, computer,operator,source,sourceid,executionid,starttime,endtime,-1071607766,0x,The "output column "COL1" (125)" failed because truncation occurred, and the truncation
row disposition on "output column "COL1" (125)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
View Complete Post