Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Passing source database as a variable

Author  Topic  hstiles Starting Member 1 Post Posted - 2010-09-09 : 09:15:07 I need to build a data extract from data stored in one of two databases. I have a table in a configuration database that tells me which database is 'live'. I wish to have a SQL statement task in an SSIS job that runs a simple query - select Live from [Connection] where ConnectionName='xxxx' if result is 0 I use databaseA if 1 I use database B how do I pass this information to the data flow step of my SSIS job?