SSIS global variable

Question

Is there something similar to a global variable in SSIS? I have 4 variables (FromAddress, ToAddress, ...) that will be used in all packages (32). Therefore, if I can install them only once, it will be very easy to use in all packages and save my time. Please inform.

Answer 1

SSIS has variables that can be global for a package, but to cover several packages I can come up with the following options

Passing variables

Have a main package, define a variable and pass the value as a parameter to all the packages that it calls. Call the variable with the same name in all packages for easy identification.

configuration file

Use the same SSIS configuration file through packages and save the value there.

Environment variable

Use a Windows environment variable that is read from other packages

Registry value

Store in the Windows registry and read for each package - make sure that you store it under a tree that all packages can see, otherwise you may run into permission problems. For example, HKLM

Search Database

Save the value of the table structure.

Answer 2

You can create local variables in your scripts. Any variable created in a script is local to that script only. You can also create global variables (through the Variables slide window) that can be covered for the entire package or a subset of the package.

Answer 3

You can use package configurations (using a DB database file, XML, environment file or registry setting) to store these values, and each of the 32 packages can refer to the same configuration, rather than setting variables in each package.

Answer 4

You can use the configuration database to retrieve such values ​​for multiple packages.