SSIS is exporting a table to a text file (fields are separated by a pipe delimiter) and a field with LF is creating an extra row in the output text file.
In SSIS 2017, I am exporting a table to a text file (fields are separated by a pipe delimiter).
Problem is some fields have a LF (line feed) which causes the output text file to contain more rows than the query.
The rows that has a field with a LF gets cut in half and the export file shows 2 rows (1 row has the 1st half of fields, the 2nd row has the remainder fields).
How do I solve this?
Thanks.
Problem is some fields have a LF (line feed) which causes the output text file to contain more rows than the query.
The rows that has a field with a LF gets cut in half and the export file shows 2 rows (1 row has the 1st half of fields, the 2nd row has the remainder fields).
How do I solve this?
Thanks.
ASKER
It's just text, not HTML or images.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
,
or you could use a more suitable format as XML, in which you could have all of your text with formating insde their proper cdata elements
OR
you could replace all your LF's before opening elsewhere with some pattern that does not include LF and replace them once you have to import or use your CSV
what kind of data is the one you are having problems with? HTML? IMAGES?