SSIS package works with Windows account, does not work with sqlserver sa account
Some SSIS permissions.
I am calling SSIS package in my .net console application with
Package pkg = app.LoadFromSqlServer(packagePath, serverName, serverUsername, serverPassword, dtsEvents);
It works when manually launched using accout window, but fails with the above call in my console application.
Shouldn't you be running with sql server sa account?
source to share
There are many reasons why it does not work when run under a different account, you should receive error information to avoid trying to fix it blindly. It looks like you are supplying a dtsEvent parameter - so your application should receive an error. Another way to get him to learn the package. Collect stubs after execution or turn on SSIS logging and check the error log.
Please update the message after the error message appears :)
There is also a KB article on how to troubleshoot these errors: http://support.microsoft.com/kb/918760/ .
But it just lists many possible causes of errors - to figure out your problem, you first need to get an error message.
source to share