Tuesday, January 27, 2015

Execution of a batch file within SSIS fails in Sql Server Agent Job

If you run the package "manually" the folder recognize you as YOUR_NET/YOU and by the way that you have rights on that folder the package run without problem. If you want run the package from SQL Agent the package recognize SQL as YOUR_NET/SQLAGENT and by the way the SQLAGENT has not right in that folder the package does not run. Ask to your network administrator to set up the folder giving access as admin to the user YOUR_NET/SQLAGENT.




Please mark as answer if this post helped you

No comments:

Post a Comment