Home Forums SQL Server 2005 Administering SQL Server Agent : Job Failure RE: SQL Server Agent : Job Failure
SQLBuddy123
One Orange Chip
Points: 28294
More actions
March 26, 2014 at 12:52 pm
#1700443
Create a credential with your ID and a SSIS agent proxy with that credential. Then run the job using that credential.
http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/
--
SQLBuddy