You are here: Passing variables to an SSIS package « MsSQL Server « IT news, forums, messages
Passing variables to an SSIS package

Posted by psion on 07/27/07 20:51

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация