Using single Environment variable for multiple packages... -
11-14-2006
, 07:00 PM
Hi all,
I'm trying to use a single environment variable as SQL Indirect Config for
my SSIS packages. While this works fine most cases I ran into problems when I
have multiple packages run at the same time.
The first step of my SQL Agent jobs use the SETX command with the /M
parameter to change the configuration filter value of the environment
variable to be used for the package in question.
I notice that sometimes the packages will pick up the correct value from the
Environment variable but at other times they don't.
Any suggestion on this issue would be appreciated.
cheers! |