April 9, 2008 at 3:46 am
Hi i get a error when i run my SSIS package. Here is the message
Error: 0xC02020A1 at import file, Flat File Source [1]: Data conversion failed. The data conversion for column "su_supplier_code" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
Error: 0xC020902A at import file, Flat File Source [1]: The "output column "su_supplier_code" (61)" failed because truncation occurred, and the truncation row disposition on "output column "su_supplier_code" (61)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
The funny thing about this is when i run the job a 2nd time it works fine.
Has any one any idea about this error or why the job would work fine the 2nd ?
April 9, 2008 at 6:19 am
The error message is pretty clear - you have a portion of your test file being put into a fields being called "su_supplier_code" and the data you are importing from the file cannot be converted to the data type of the field. This could be data that is too big for the field length or something a little harder to find.
As for why it works the second time you run it - I have no idea what your package is doing. Do you pick up the same file each time the package runs? The second time you are running the package you are probably not picking up the bad record.
April 9, 2008 at 7:32 am
Hey thanks for the reply, i had a look at the file and it seem that the file had some funny characters in the column and its that which is causing the problem. Am not sure they it works the 2nd time about as its still the same file..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply