SQL 2005 Agent Job Error : SQLSTATE 22001
Posted on 2010-09-17
SQL2005.Ent.x86.SP3 is running on W2K3.Ent.x86.SP2.
One of it SQL Agent job frequently fails with the following message :
"String or binary data would be truncated. [SQLSTATE 22001]"
It seems like some data value doesn't meet the column data type settings when inserted into the table especially exceeding max char length.
Is there any way to capture the data value that causing this problem?
This SQL agent job inserts a set of records from one table to another as one shot ( no loop ).
Thank you for your help.