ERROR MESSAGE: failed because truncation occurred

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

ERROR MESSAGE: failed because truncation occurred

Author

Topic

InPharmative
Starting Member

12 Posts

Posted - 2008-07-16 : 10:47:19

ERROR MESSAGE:
The "output column "Column 27" (91)" failed because truncation occurred, and the truncation row disposition on "output column "Column 27" (91)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

What I am doing is getting a flat file (*.PCX) and pulling the data from each line. The Fields are comma delemited but I have one field that has double quotes around it.

How can I strip the quotes?

Thanks Michael Webb

Thanks Michael Webb
www.InPharmative.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-16 : 10:57:38

Use replace function to remove it while extracting data from source.

InPharmative
Starting Member

12 Posts

Posted - 2008-07-16 : 11:08:28

Awesome can you give a little more direction. Sorry !!

Michael

Thanks Michael Webb
www.InPharmative.com

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-16 : 12:03:33

If you cannot change the source:
Use the SSIS Data Flow Item "Derived Column". There you can use an Expression like REPLACE([Column 1],"\"","")

Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources