Post reply

Setting DTS Global Variable

  • December 8, 2003 at 12:17 pm

    #106953

    Good afternoon,

    Can anybody tell me if there is a way to set a Global Variable for all DTS packages at the same time and not to mess with the packages layouts (graphics) if the modification will be made?

    Thank you in advance.

    Alex

  • December 8, 2003 at 3:51 pm

    #485206

    To set Global Variables and save the changed values you will need to open the package and save it. Doing this via the DTS Designer will preserve the layout but is not something you want to be wasting your time one if you have more than a few packages. Modifying the package programmatically WILL lose the layout. There is no way to avoid this.

    Another approach would be to set all the global variables dynamically. Maybe from a table in the database. Then you won't need to mess around with the packages to changes the values.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

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

  • December 9, 2003 at 7:57 am

    #485321

    Thank you Philip,

    I had this feeling that there is no way we can keep the layout of the package while modifying it programmatically.

    But still nobody answered the 1st part of my question: do anybody know if there is a way to set one global variable for all packages in SQL Server?

    Thank you in advance.

    Alex

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

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