Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    21

    Unanswered: how to export data from sql to csv format using DTS?

    can anybody help me with exporting data to csv format....?

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    in the data transformation step use a text file(destination) as destination and give the output file name as .csv with column delimiter as "comma". try it out and let us know.

  3. #3
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    21
    Originally posted by rohitkumar
    in the data transformation step use a text file(destination) as destination and give the output file name as .csv with column delimiter as "comma". try it out and let us know.
    but I need it to do it in Visual Basic component... I have the transformations to xml, xls, dbf, mdb written...now i need to add export to csv... what is the connectionProperties("extended properties") for csv format... do you know?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •