Dynamically change the ServerDB name in SSIS connection manager

Question

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?

possible duplicate of How to parameterize database connection string in an SSIS package? This is the solution that we use (store all configuration parameters in a database table), so that if your server name changes, you just UPDATE the configuration table and you're done. — Pondlife
– Pondlife, Commented May 17, 2013 at 16:28
If the packages are stored as files, you can just find/replace the hostname O.o — tommy_o
– tommy_o, Commented May 17, 2013 at 21:38
Possible duplicate of SSIS how to set connection string dynamically from a config file — Michael Freidgeim
– Michael Freidgeim, Commented Nov 15, 2016 at 19:24

Metaphor · Accepted Answer · 2013-06-10 13:45:16Z

2

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.

answered Jun 10, 2013 at 13:45

Metaphor

6,42512 gold badges58 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamically change the ServerDB name in SSIS connection manager

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related