Post reply

How to add date as column with a table, while exporting to a text file using DTS

  • April 25, 2006 at 12:53 am

    #167858

    Hi,

        I've a table with millions of records. How to append date to the table while exporting it to a text file using DTS? the date should be start date of the export process(process may take long time)

  • April 25, 2006 at 8:36 am

    #634046

    Use the GETDATE (or GETUTCDATE) function. To ensure that you're using the right date, store it in a variable at the start of the process, and just reference the variable in your column list. Use the CAST function to get it in the right format.

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

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