Export Tool Suggestion for Exporting Data From Multiple Tables

  • Hello,

    Any suggestions on methods or tools to export table data to text files/CSV in one step ie: select 5 tables exports to 5 text files?. I would also like the first row in each output file to include the column headings.

    bcp does not include column headings. DTS includes column heading, but only allows 1 table to 1 text file export at a given time.

    i have a hundred tables that i was hoping to do in one step.

    Any thoughts/experiences are greatly appreciated.

     

    Many thanks. Jeff

  • In DTS you can set up mutiple source and destination pairs.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply