I am trying to execute a SSIS package by calling a web service. The service is running on a machine with SQL server 2005. The package executes by itself. if I am logged on the machine since it is using my credentials. when this package is called through the service, it fails because the password is not stored in the package. I tried running using impersonation using a domain account and still have not luck. Can any body help? I am sure it is caused by missing db connection password. Here is the code:
pkg = app.LoadFromSqlServer( "\\MyPackage" ,"MyServer","UserName",&q ...
Go to the complete details ...