November 18, 2011 at 2:39 am
I am new to SSIS I am getting this error when importing from CSV to the DB
[Flat File Source [1]] Error: Data conversion failed. The data conversion for column "col10" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
If I don’t map “col10” its fine, for the life of me I cannot work out how to output the failing row to an error file and carry on.
I have set up a flat file and pointed the red arrow at it but it still fails. Obviously this is fundamental and basic but I just can’t work it out . please help me with dummy instructions sorry
November 18, 2011 at 3:27 am
Some dummy instructions: 🙂
in the editor of your flat file source you need to configure the error output.
For the column col10, put the error configuration to "Redirect row" for truncation.
This will cause the rows to go to the error path if a truncation error occurs on col10.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply