dbTalk Databases Forums  

Passing variables to an SSIS package

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Passing variables to an SSIS package in the comp.databases.ms-sqlserver forum.



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

Default Passing variables to an SSIS package - 07-27-2007 , 03:51 PM






Hello,
I am trying to pass a variable before run time of an integration
package, that would tell that package which other packages to run,
based on "precedence constraint" > Expression > @listid == 16.

The way it's set up is an sql task, without an sql query, is first to
execute. From this sql task, four output connections lead to 4
different packages, each one having a different precedence constraint
value from @listid. Whichever listid value is entered before run time,
that package would be run.

With this setup, the package executes without errors, but nothing
occurs.

Can anyone help?

Thank you,
Krzysztof


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.