dbTalk Databases Forums  

Using single Environment variable for multiple packages...

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Using single Environment variable for multiple packages... in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
blueoyester
 
Posts: n/a

Default 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!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.