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