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.
| 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,kowalskykowalsky |
 |
|
|
|
|
|
text file with long rows