Sunday, March 6, 2011

When calling a SSIS using LoadFromSqlServer, does the user account have to have special permissions?

Hi,

when calling a SSIS package (C# app) using LoadFromSqlServer, does the user account have to have any special permissions on the database or server?

I can't seem to view the packages in EM at the moment ...

From stackoverflow
  • I don't know the answer exactly, but where an SSIS package is run from is important. If I run it from Visual Studio, it's using my account and permissions. If I load it to the server and just try to run the package directly, it's using something else (and usually fails because of they way our servers are set up). If I run it from a job on the server, it uses the server SQA account, with the permissions from that account.

  • You will need to grant some rights to the users which need to run the SSIS packages.

    This page should provide the information you need.

0 comments:

Post a Comment