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 2008 Forums
 SSIS and Import/Export (2008)
 text file with long rows

Author  Topic 

kowalsky
Starting Member

29 Posts

Posted - 2014-10-20 : 11:32:31
Hi all,
I have a text file with fields separated by pipes that are about 1300 characters long.
When I open the file with Notepad the lines are wrapped as Notepad does not accept more than 1024 caharacters on one line.

How do I import this text file using SSIS?

Thanks,
kowalsky

kowalsky
Starting Member

29 Posts

Posted - 2014-10-27 : 12:34:34
Thanks everybody,
it seems that as long as you pick your delimiters and ignore the fact that Notepad is wrapping up the lines, the Flat File Connector will understand correctly the pipes and CRs and will stack the rows correctly. No wrapping in the SSIS Flat File Connector.

Thanks,
kowalsky

kowalsky
Go to Top of Page
   

- Advertisement -