August 8, 2006 at 8:23 am
Hi
I am trying to use the export wizard to export data from a SQL Server table to a fixed width text file. The problem seems to be the row delimiter is being ignored and multiple rows are being placed on the same row. This worked fine in SQL 2000.
Thanks
Danny
August 11, 2006 at 8:00 am
This was removed by the editor as SPAM
August 15, 2006 at 9:58 am
Try using Ragged Right. If I remember correctly, the row delimiter doesn't work the way we expect it to in Fixed-Width. CR and LF are just treated as two characters in the row. You'll need to set the row length appropriately and ignore your row delimiter character(s) if you want to use fixed width.
I'm still a little shaky on this logic myself, but eventually resigned myself to using ragged right just to avoid the pain of trying to use fixed-width. 😛
-Pete
October 6, 2008 at 1:47 pm
I've found that Excel is better at recognizing the delimiters. You could open the file in Excel and save as csv and then import the newly created csv. It may add a layer to the process, but it seems to work. I am struggling with the same problem that you are expriencing and I'm trying to sell the Excel idea to my user.
I'm new to SSIS so there is probably a better way than what I'm suggesting here. If anyone has a better idea, I too would like a better solution.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply