Sunday, February 12, 2012
After export to flat file, all records are in one line, help!?
I created a package that exports contents from a table to a flat file but all my records are being displayed in a single record. where do i configure it to where each record has its own line. the columns in the flat file are fixed.Did you specify a row delimiter? If you did, and specified a LF as the delimiter, you may need to view the file in Wordpad or something. Otherwise, I'd guess there is no row delimiter chosen.|||You should pick fixed width with ragged right for the flat file type if you want a row delimiter, or in line with Phil's suggestions, you can set the column delimiter on your last column to {CR}{LF}.|||THANKS PHIL AND JWELCH, BOTH YOUR INPUT WAS VERY HELPFULL...THINGS ARE WORKING NOW.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment