October 28, 2009 at 3:46 pm
I have a view that returns about 20 columns and I am to write those 20 columns into a fixed flat file. I have been consistently getting the below error. I even tried ignoring failure on Truncation on all the columns but still the same problem persists. Column 0 only has 4 characters. Even the table doesn't have any data that has length greater than 4.
Any help on this topic would be greatly appreciated.
[Flat File Destination [11087]] Error: Data conversion failed. The data conversion for column "Column 0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
October 28, 2009 at 4:02 pm
I would check your flat file connection manager and make sure your column widths are defined correct.
Any chance there's a character in your source data that is causing the problem?
".....or one or more characters had no match in the target code page."
October 28, 2009 at 4:05 pm
Column widths are correct. Column 0 contains 5659 for all the rows. I don't see any special character in this column to cause problem.
October 28, 2009 at 4:09 pm
You may need to check all columns. If this is a fixed width file, the error may be misleading as a problem with the data for any column could cause a wrap-around effect that manifests itself as an error with Column 0 when in fact the error was on the line prior within a different column. Make sense?
October 28, 2009 at 8:27 pm
Yup.
Used Derived Column Transformation and got the substring of the desired length on all the columns.
Package ran sucessfully.
Thanks for the help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply