I am trying to export a 512 char fixed-length flat file with line feed at end of line
using SQL 2005, but the export does not allow the option. It exports the data into
1 long continuous string.
I tried ragged-right option, but the row length varies depending on what text is in
the last column.
Can anyone point me in the right direction?
Should I be using BCP utility for a fixed-length export?