December 14, 2005 at 5:19 am
Hey i have a issues with a DTS am running to collect data, am getting the following errors.. any help would be great, i think its somethign got to do with the actually data but i've 23,000 rows in my table...
Executed as user: CR\jobs. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.
December 14, 2005 at 8:03 am
Narrow this down to the column in question by building a test transform with reduced columns (if the error does not give you this).
Use the len() function on the source column to find the size of records that won't fit into the destination.
e.g. select * from SourceTable where len(SuspsectColumn) > 40
If you can't run this check directly on the source bring the data into a test table first (use the create button to build the destination table with the column sizes needed).
December 14, 2005 at 9:20 am
Is this error occuring during a "Transform Data Task"? The easiest way I've found to find rows that error in a large import is to go to the "Options" tab in "Transform Data Task Properties", set a path for an Exception file, and set "Max error count" to 999. Then run the task. The Exception file contains all the rows and a detailed reason as to why the row didn't make it to the table. Hope this helps.
Cheers..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply