SQL 2005 - Export table to a fixed width file.

[gelangov]

I want to export a table into a "fixed width" file using SQL 2005
import export wizard.

This is the version I have:
SQL Server 2005 - 9.00.2047.00

For some reason it joins all the rows together. For EX: if the table
is like this:
Create table Mytable (col1 varchar(50) null, col2 varchar(60) null,
col3 varchar (100) Null)

Insert into MyTable values ("abcdef", "12345", "8900")

Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
Insert into MyTable values ("yyyyyyyyy", "5555555555555555",
"6666666666")

Insert into MyTable values ("abcdef", "12345", "8900")

Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
Insert into MyTable values ("yyyyyyyyy", "5555555555555555",
"6666666666")

It is not exporting every row in a single line. Actually if I open it
in "Ultra Edit", it is all in one line.
I used to do this regularly with SQL 2000 import export wizard and it
exported every row in one line.

I looked at the setting:

The header row delimiter has {CR}{LF}
Code page has 1252 Ansi-Latin.
In the Advanced tab:
String:dt_str.

I tried changing the header row delimiter to just {CR} or just {LF}.
Also I tried changing the string to dt_text and nothing seems to help.

Please help.

Thank you