Dev and Live SSIS connections
-
Hi
I have a SSIS package running on both a dev server and a live server.
there are a number of connections that connect to other dev and live servers that differ for whether i am working on the dev or live system.
is there a way of switching between the two without having to go into each connection and changing the information?
thanks in advance 🙂
-
In order to change connections dynamically, you need to program them using script task in SSIS.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
You could use a CNAME alias in DNS to map to either your Dev or Live server.
That way, when you wish to change the connection, you change the alias and not the connection string in your package.
Andrew
-
good idea thanks
i have also found this
-
erics44 (1/29/2013)
good idea thanksi have also found this
Thats the way I would suggest,
Personally I would invest in setting up the SQLServer stored variables, as this way you can store the configs on each server and even encrypt any passwords that you have, although you do need to set up the original connection to the SQL server using an XML configuration.
_________________________________________________________________________
SSC Guide to Posting and Best Practices -
works like a dream mate 🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply