February 1, 2009 at 9:12 pm
I am using the database export wizard to export data from a table to a text file. In one of the steps in the process there is an option to set a column and record delimiter for the destination file. However, both options are greyed out and cannot be set. How do I get these options to be accessible?
Thanks,
Ken Cross
February 1, 2009 at 11:28 pm
Hello,
When you specified the ptions for the Flat File Destination, did you select the “Delimited” format? If you chose “Fixed Width” then the “Row Delimiter” and “Column Delimiter” options will be disabled.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
February 2, 2009 at 8:11 pm
Yes, I did specify "fixed width". However, the problem I am having is that in the resulting text file the data is "wrapped" when I need to have one record per row.
Thanks.
February 2, 2009 at 8:32 pm
To follow up on my last post, I need each column in the text file to be in the same location. It will transmitted to the mainframe and processed through a COBOL program. I tried doing the same thing in SQL 2000 and I was able to set the row delimiter even though I chose the "fixed width" option. I hope they didn't take this option away from me!
Thanks,
Ken Cross
February 3, 2009 at 10:39 pm
Hello again,
When you say the record is being “wrapped” do you mean that control characters (e.g. Carriage Returns) are being inserted part way through the record?
If so, are the control chars always added in the same place in the record?
Could you possibly post a sample of the output file?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply