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)
 How to exclude "LF" at the end of flat file import

Author  Topic 

GhantaBro
Posting Yak Master

215 Posts

Posted - 2009-11-17 : 10:42:34
How can we ignore Line Feed "lf" while doing import of fixed width flat file using SSIS? Rite now I have made the last field one char longer and it is importing the Line Feed too.... Thanks for help.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-17 : 10:46:21
I remember that I have made it a column and ignored it.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

GhantaBro
Posting Yak Master

215 Posts

Posted - 2009-11-17 : 10:48:10
hmmm I was thinking about that, but wanted to check if SSIS can handle that without taking that route... Thankyou webfred I will do that...
Go to Top of Page
   

- Advertisement -