SQL Server Performance

What is best way to pass global values

Discussion in 'SQL Server DTS-Related Questions' started by drybagel, May 6, 2004.

  1. drybagel New Member

    Hi,

    Background: We have a daily job that we run via Enterprise Manager. Each step in the job runs a separate DTS package. We'd like to pass in a directory name and some other "global" parameters into each of these DTS packages but cannot figure out a good way to do this. I have tried a simple example using a .INI file and a Dynamic Properties Task - but I was wondering if there was even a simpler way to set global variables that would be available to each of the DTS packages and even to .BAT files.

    Thank you.
  2. gaurav_bindlish New Member

    How about putting them in some table in the database and reading from there?

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  3. drybagel New Member

    OK, thanks. I will look into that -- but (I know I'm being stubborn) I was still wondering if there is some way to set global variables like I used to do in old .bat files in DOS and then have the DTS packages access these variables.

    Thanks again.

Share This Page