I've got a Web Service and I have to set the consumer title and password to have the ability to consume this particular service..
The webservice works fine after i run it in your area, however this doesn't occur around the server because the password sheds once the package is moved on another server.
I wish to know whether you'll be able to set the password via a variable? I attempted to make use of the bond expression but wasn't effective.
When saving the SSIS package set the 'Package protection level' to 'Do not save sensitive data'. To include a configuration file the package must be put into a visible Studio project. In Visual Studio's SSIS menu choose 'Package Configurations' and give a configuration file for your project and choose the connections to incorporate. You'll be able to deploy the package and config file for your production server.