Changing connection of SSIS package at runtime 1

[wawalter]

Hello,

I have a DTSX package I am running from a C# program that is working fine. Now I want to be able to change the connection string of the SQL Server source data at runtime.

I've been messing with the Connections collection of the package, but I can't get it change.

Thanks for any help,
Bill

 

[mrdenny]

You will want to use a config file to set the new connecting string to an SSIS global variable. Then use a script task to get the value from the SSIS variable and reset the connection object.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[wawalter]

Thanks, I'll give that a try.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com