Post reply

Adding Global variable to import

  • November 28, 2001 at 4:32 pm

    #104638

    Hi all

    Just wondering if anyone knows if I can include a global variable as part of a DTS data pump.

    To set the scene. On a daily basis we get a file from our mainframe guys that holds a list of ID numbers. The file name is the date the list was extracted from the mainframe.

    We would like to have the date the IDs where extracted, as well as the IDs themselves, imported into our table.

    I can pickup the file and store it's date easily enough, but how do I include that date in the transformation task?

    Hope someone can help.

    Thanks

    Phill

    --------------------
    Colt 45 - the original point and click interface

  • December 12, 2001 at 8:40 am

    #421036

    Check this out :

    http://www.sqldts.com

  • December 12, 2001 at 10:18 am

    #421048

    If this is SQL 2000, you can use the Dynamic Properties task to change the data pump.

    Steve Jones

    steve@dkranch.net

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

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