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)
 ssis defaulting string length to 50 in a flat file

Author  Topic 

lgr811
Starting Member

2 Posts

Posted - 2009-07-22 : 12:38:32
i almost new to ssis, i have a flat file with variable length fields, my table's fields defined are varchar(MAX) buy ssis is truncating my strings to 50, what can i do ?

Leo

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-07-22 : 13:39:45
Go to the Destination File Manager and change the length of the column from the column mappings.
Go to Top of Page
   

- Advertisement -