export to csv

  • hi all.. i'm new to dts and trying to export to a csv

    i go though the dts wizard but nowhere can i see how to export data to a csv file..

    what am i missing?

    been stuck on this for ages!

  • When you start the wizard it will ask you for a data source - after entering your server and DB, click next and it will ask you for the destination.  Near the top, click on the dropdown and scroll to the bottom to get text file as the destination.  Then click on properties to set your preferences such as single or double quotes, column and row delimiters.  You can probably just use the defaults.

    Good luck.

    Bill

     

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

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