Is it possible to create a proxy account to run SSIS package as a job using a SQL Login (Testlogin) created on ServerA on a different domain?
I get "Description: Failed to acquire connection "ADO.Net.linked servername." The password to the connection blanks out when running it as an SSIS package job.
I created a proxy to run this job using the sql login (TESTLogin) on ServerA and I now get this error "Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 1).
Any imputs how to run this ssis package as a job. I can execute the package ok when I hard code the sql login password in the connection manager--ssis designer