When we try to execute a SSIS package from a SQL Server Agent job it fails with the message "Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account." if the account under which SQL Server Agent Service is running and the job owner is not a sysadmin on the box or the job step is not set to run under a proxy account associated with the SSIS subsystem. What is this exception about? What causes it and how do I resolve it? For more details, click here.
Monday, November 29, 2010
Subscribe to:
Post Comments (Atom)
http://balkidba.blogspot.com/2011/09/how-to-schedule-and-run-ssis-package.html
ReplyDelete