It has been a pain to schedule a Sql Agent Job for SSIS packages by using the new SSIS package step type. The security and permission problems are so complex that we can't figured out how to setup the proxy or account permissions. I have read the MSDN help and some step by step instructions but I have no luck by doing that.
Finally I decided to change the job step type to Operating System (CmdExec) and using the dtexec command to run the package directly. And this solved the permission problem immediately. The Job runs more than happy and we don't have the pain anymore.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment