SSIS package using INSERT stops because the from column is CHAR(10) and the to col is CHAR(2) Finally four characters were sent

#1

Hello and thank you in advance for any help!

The error message was thrown because a CHAR(10) field was moved to a CHAR(2) field and finally an operator used the extra space and placed 'SASK' instead of 'SK' into State/Province.

The first step of our SSIS package has an error message with no details. Notice that I cannot see the details of the error mesage:

Date 2/2/2009 10:16:12 AM
Log Job History (Cpy to ElGrande)

,[REC_DATE] ,[APN_STATUS] FROM [CC_WKF_TRANSFER_NEW]" failed with the following e... The package execution fa... The step failed.

Any ideas how we can get ALL the error message's detail and trap for this error.

Thank you very much in advance for ideas!

--John deCoville

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS package using INSERT stops because the from column is CHAR(10) and the to col is CHAR(2) Finally four characters were sent

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

SSIS package using INSERT stops because the from column is CHAR(10) and the to col is CHAR(2) Finally four characters were sent - 02-10-2009 , 04:57 PM