CODEWITHSUNDEEP
sql-serverdatabasessisconnection
Chris White
Chris White

Reputation: 21

Dynamically change the ServerDB name in SSIS connection manager

We have a few 100's of SSIS packages in our environment. Last night we moved our database from one server to another and renamed it. We now need to go into all of packages and change the connection manager to point to the new database server name.

We want to know if there is a way to create a @variablename that we can store our new server name in it (i.e. 'ELITEDB.SIRS-db') in it so we can then put the @variablename into the Connection Manager area. This way if we move servers again in another year we only need to make this change once because the new @variablename will be able to pull the new Server name.DBname.

I hope this makes sense to the masses out there?

Upvotes: 2

Views: 7646

Answers (1)

Metaphor
Metaphor

Reputation: 6415

If you're working with SSIS 2012, just right-click on the connection and select "Parametrize". Thereafter the connection will be settable with the parameters you create.

Upvotes: 2

Related Questions