How to change DBName in connstring dynamically

[brookk]

Hello All,

I have to get database details for reach database on the server. In my SSIS package, I am already having a SQL task which get the dbnames in a result set. How do I dynamically change the dbname in connection string in my ForEach loop before it executes another SQL task which is database dependent.

Thanks much,

 

[Alan0568]

First you can create package variables of type string for the whole connection string, server name or just initial catalog properties (amongst others).

Modify the properties of the connection by expanding the 'expressions' and assigning your variable(s) to the property(s)

To update the variables dynamically you can use Dts.Variables within a script task .......

http://msdn.microsoft.com/en-us/library/ms135941.aspx