SQL 2005 -- export table to a "fixed width" flat file -- Posting again

[gelangov@hotmail.com]

I am sorry, I am posting this message again, since I did not get any
reply.

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" , "55555555555555 55",
"6666666666 ")


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


Insert into MyTable values ("xxxxxxx", "11111111", "22222222")


Insert into MyTable values ("yyyyyyyyy" , "55555555555555 55",
"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

[bell.frank@gmail.com]

Re: SQL 2005 -- export table to a "fixed width" flat file -- Posting again

I'm having the same problem now. Were you ever able to resolve this?
It's weird since SQL 2000 works fine.
gelangov@hotmai l.com wrote:

I am sorry, I am posting this message again, since I did not get any
reply.
>
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" , "55555555555555 55",
"6666666666 ")
>
>
Insert into MyTable values ("abcdef", "12345", "8900")
>
>
Insert into MyTable values ("xxxxxxx", "11111111", "22222222")
>
>
Insert into MyTable values ("yyyyyyyyy" , "55555555555555 55",
"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