Friday, February 10, 2012

Connection problem when deploying

Hi all,

Here is my problem, I know there are already Posts about that but I still run after the same problem ...

I have a package with a connection in the connection manager. I use the xml configuration file to adapt my package when deploying it on the production server. In the xml file, I chose to modifiy the Connection String, the user name and the password.

I set the ProtectionLevel propertie to "DontSaveSensitive".

But when I deploying and scheduling my package on a other server, the execution failed because it can't Acquire the connection.

Did I miss something else in the configuration or in the properties ?

Thank you

Are you sure you did a server restart to refresh the environment variabe on the other server?

I use environment variables to tell where is the xml config but it looks like that if I change the xml, even though the variable still resolves to the config file, the updated values are still unavailable, untill I restart the server.

I do not like it, I have to restart a server that should not be restarted but, that the only way i could get it to work.

Philippe

|||Hello,

No I didn't restart my server but I don't have to because I'm not using environment variable.

No comments:

Post a Comment