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. :-D Everything works now.
Leaving this post in place in the hopes that it helps someone else with this issue.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog
, and Twitter
.Freelance Writer: ShadowrunLatchkeys: Nevermore
, Latchkeys: The Bootleg War
, and Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.