SSIS 2008 R2 - How to dynamically change connections during runtime

sql-server sql-server-2008 ssis ssis-2008
GordyII picture GordyII · Feb 16, 2011 · Viewed 13.5k times · Source

I am using SQL Server SSIS 2008 R2.

I want to dynamically change a connection manager for OLEDB during runtime to point at a database determined during the running of the package.

This means that I cannot use configuration files.

How can I do this?

Answer

Sam picture Sam · Feb 16, 2011

You would use expressions and populate a variable with the connection property you would like to change. In the properties of each object, there is a field called expressions, which you can open up and dynamically change anything.

Related questions

How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (including quotation marks) My destination column is a SQL Server 2008 database table of type date (not datetime) In my Flat …

Read More
Temporarily disable all foreign key constraints

I am running an SSIS package which will replace data for a few tables from FlatFiles to existing tables in a database. My package will truncate the tables and then insert the new data. When I run my SSIS package, …

Read More
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:- for the destination I chose "SQL server native client 10". …

Read More