May 7, 2008 at 7:53 am
When using the SQL Server Import and Export Wizard to export data from a database to a flat file it seems there is no option to select what character I want to use for a column delimiter. How can I create the DTSX such that it generates tab-delimited output? (I'm using the saved DTSX file in an automated task that uploads the output file...perhaps there's another way to automatically generate the tab-delimited file.) Thanks in advance! -Alex
May 7, 2008 at 11:36 am
Alex
You can set the column delimiter in the SQL Server Import/Export wizard, the first screen is choosing the data source (SQL Server), second is choosing a destination which in this case should be flat file destination, next is rather to copy the table or write query, either should suffice depending on the data needed, and then the magic screen appears, configure flat file destination, under the column delimiter section, there is TAB{t} in the drop down menu. Choosing that feature will produce a tab delimited output
Marvin Dillard
Senior Consultant
Claraview Inc
May 7, 2008 at 12:03 pm
How did I overlook that?! Thanks for the tip and taking the time to help with something that was so obvious.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply