I have a problem with one SQL Server Agent Job. There is one step which executes a SSIS package, I receive a successful message but the SSIS package don't be executed.
The SSIS package owner is local administrator on our SQL Server - he is also member of the sa group and the Microsoft SQL Server job will be executed with this user.
I don't know why this SSIS package will not be executed... In this SSIS package there will be executed two other packages but these ones are in the same directory. I also checked the boxes in the connection manager options at the job step properties.
If I execute the package manually with the execute package utility everything works fine.
On a few pages some people write that I have to create an proxy account but is this really necessary and if there is a problem by using this user why don't occur an error?
I hope anyone has an idea. Thank you!
I find a solution for this problem. I created a batch file which executes this packages with the dtexec.exe
Then I created a task (in the server task scheduler) which executes the batch file - now I have an automatically daily import without any problems.