Hi, I have created a package in y system and have a config file also which has DB connections information. My team is also using the same connections. When my teammate is trying to execute it in his system he has to refersh d DB connections evrytime. let me know is this the way it works? is it not possible to jus click on execute the package to run, because when we do that it shows an error in Connectons. Kindly help

does your team mates use same package you wrote ? or they work on their own pacakge?http://www.rad.pasfu.com

It is d same package.. we are trying to execute the same package in different system... I have created in my system ..so i do not have d problem of again refreshing the DB connections..But he has.. As we are using a global User id and password...we expected the package to run without making any changes to the connections..

how did you set ProtectionLevel of package? by default protectionLevel of package is EncryptSensitiveWithUserKey this means that if any other user, want to open or execute this package, he will not have sensitive data like connection passwords change it to EncryptSensitiveWithPassword, then set a password and let other users know this password, once they enter this password they don't need further connection refreshinghttp://www.rad.pasfu.com

If the other team runs it first will you have the same problem? I just want to know will they have any error, want to make sure that you both are using the same scop variables in the config file -- I think that REZA has the answer, I am using the same config for few packages without any problem. Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).