Posted by bell.frank on 12/07/06 00:30

I'm having the same problem now. Were you ever able to resolve this?
It's weird since SQL 2000 works fine.
gelangov@hotmail.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", "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

[Back to original message]