Post reply

file .csv

  • September 3, 2003 at 2:38 am

    #106936

    Hi!!

    I would like to know, how is it possible to create a .csv file using a dts, extracting data from a table.

  • September 3, 2003 at 2:59 am

    #472325

    quote:

    Hi!!

    I would like to know, how is it possible to create a .csv file using a dts, extracting data from a table.

    Create a new DTS package and create a new Connection (type Text File (Destination)) and set target filename and properties: delimiting style (delimited or fixed), file type (ANSI, OEM), row delimiter (CRLF, CR, LF, ...), column delimiter (comma, tab, ...), text qualifier ...

    Create 2nd connection to SQL and create TDT between connections to extract data from SQL to CSV file.

    Or you can use export wizard on one table to export one table to one file.


    ****************************************
    1: The question is ... "What is a MahnaMahna"?
    2: The question is ... "Who cares?"
    ****************************************

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

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