July 16, 2013 at 4:45 am
I have an SSIS package that has been working fine up until now. I added a column to the flat file connection manager and suddenly it's blowing up.
Here's what I have:
ERROR: The data conversion for column "Final" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."
SQL Server 2008
Code Page SQL_Latin1_General_CP1_CI_AS
Data flow task has OLE DB source pointing to a stored procedure.
Metadata is non-Unicode (always has been and never got converted).
Row Count transformation exists between Source and Flat File Destination. No other transformations.
Destination is fixed width.
In the Advanced tab of the flat file connection manager, I added a 5 character string after the final 2 character string column.
And you know what I just realized as I typed this? I forgot to change the input on the original final column from 0 (the default non-updatable value for a final column) to 2 after I added the new column.
Nevermind. 😀 Everything works now.
Leaving this post in place in the hopes that it helps someone else with this issue.
July 16, 2013 at 4:50 am
Whoah, I have read all of this text for nothing? 😉 😛 😀
I had the same issue once during a SSIS training. It took me a few minutes before I found it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2013 at 4:57 am
Thanks for the assist, Koen.
Blame DBCC Timewarp. You gave me the solution before you even read the post. @=)
July 16, 2013 at 5:00 am
Brandie Tarvin (7/16/2013)
You gave me the solution before you even read the post. @=)
That's how I roll 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply