Passing variables to an SSIS package

From: psion <krzysztof.miszczak@xxxxxxxxx>
Date: Fri, 27 Jul 2007 13:51:21 -0700

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

.

Prev by Date: Kerberos setup on windows 64-bit SQL Server 2005
Next by Date: MS SQL IF ELSE condition checking
Previous by thread: Kerberos setup on windows 64-bit SQL Server 2005
Next by thread: MS SQL IF ELSE condition checking
Index(es):
- Date
- Thread

Relevant Pages

Re: DTS Import Package
... > I would like the ability to run the package multiple times within having ... >> Please note from the above, that I only have one FTP task in my package ... >> I also have one SQL Task and one SQL Task which sends ... >> transformation, I could paste it into the code section. ...
(microsoft.public.sqlserver.dts)
Re: DTS Import Package
... > I would like the ability to run the package multiple times within having ... >> Please note from the above, that I only have one FTP task in my package ... >> I also have one SQL Task and one SQL Task which sends ... >> transformation, I could paste it into the code section. ...
(microsoft.public.sqlserver.programming)
Re: Adding logic to check for existence of soource tables
... However I am transferrig data from an ODBC datasource, mySQL. ... I am new to the SSIS package designer and don't fully understand how to set ... Edit the SQL Task ...
(microsoft.public.sqlserver.dts)
RE: Temp table and rollback in SSIS Package
... SSIS had some issues with #temp tables but have never tried using them myself. ... This package has 2 connection managers, ... |DataFlow 2|>Copy data from second table ... |SQL Task 3|>Delete data from second table ...
(microsoft.public.sqlserver.dts)
Re: help assigning value to global variable
... (sql task in the package) ... second object in my dts would then pick up that value and continue. ... > Whilst we use input parameters here you want an aoutput parameter of the row ... >> I created an sql task that will get a value form a table and then assign ...
(microsoft.public.sqlserver.dts)