Post reply

How to append date to the table while exporting it to a text file using DTS?

  • April 25, 2006 at 4:55 am

    #70397

     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 7:01 am

    #634002

    What do you mean by "append date to the table"?

    If you simply want to update the table from which you are extracting data, a simple SQL call (there's a DTS task for this) at the start of the export process will work. (i.e. Update Export_Table set Exported_Date = getdate() where...)

    If it's something else, give us some details and we can help.

  • April 25, 2006 at 8:52 am

    #634055

    cross-post...follow link here!







    **ASCII stupid question, get a stupid ANSI !!!**

  • April 26, 2006 at 9:54 am

    #634366

    Create a Global Variable of type datetime.

    Use an Execute SQL Task to SELECT GETDATE() (in whatever format you want) - use the Parameters option to map the output to your global variable.

    In your task, you should be able to assign that GV to a column either through an ActiveX transform or by entering a ? in your SQL Statement and using parameters to map your StartDate GV to that ?.

    -Pete

Viewing 4 posts - 1 through 3 (of 3 total)

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