What is best way to pass global values | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

What is best way to pass global values

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.
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.
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.

]]>