March 9, 2011 at 12:55 am
Hi Folks,
i have deployed my SSIS packages in Development and Production Server. i'm maintaining the Config table in both the server where the Dev Server contains dev credentials and the prod server contains the prod credentials. what I want is i don't want to update the credentials everytime in config table , I want too pass the server name and the package should automatically take the corresponding config table either dev or prod.
For e.g : suppose i update the credentials to production server, it should take the config table in production server and use those credentials to run the package and viceversa.:-):-)
Please send your valuable suggestions:-D
Thanks in Advance!
Sabarinathan
March 9, 2011 at 5:37 am
Your question is not exactly clear to me, but I think you are referring to indirect configuration.
Basically this means that there is an environment variable (or xml file if you want) that contains a connection string that points to the configuration table.
So, on the dev machine the environment variable will point to the dev config table, while on the prod machine the environment variable will point to the prod config table.
In your package, you have a connection manager to the config table. This connection manager is updated by the environment variable, so that it automatically points to the right config table. So all you have to do is make sure that the environment variable config is at the top of the list, as this one should be applied first.
Got it? 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply