We help IT Professionals succeed at work.

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.

paultran00
paultran00 asked
on
13 Views
Last Modified: 2020-04-03
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.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
if you can export the csv with delimiters (quotes) then you could just use the file based on the quotes,, and ignore the LF
,
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?

Author

Commented:
It's just text, not HTML or images.
Get access with a 7-day free trial.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.