Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Minor change to SSIS connection manager causes error Expand / Collapse
Author
Message
Posted Tuesday, July 16, 2013 4:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:28 AM
Points: 5,584, Visits: 6,380
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.




Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1474055
Posted Tuesday, July 16, 2013 4:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 13,368, Visits: 11,148
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1474059
Posted Tuesday, July 16, 2013 4:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:28 AM
Points: 5,584, Visits: 6,380
Thanks for the assist, Koen.

Blame DBCC Timewarp. You gave me the solution before you even read the post. @=)


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1474060
Posted Tuesday, July 16, 2013 5:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 13,368, Visits: 11,148
Brandie Tarvin (7/16/2013)
You gave me the solution before you even read the post. @=)


That's how I roll




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1474062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse