when calling a SSIS package (C# app) using LoadFromSqlServer, does the user account have to have any special permissions on the database or server?
使用LoadFromSqlServer调用SSIS包(C#app)时,用户帐户是否必须对数据库或服务器具有任何特殊权限?
I can't seem to view the packages in EM at the moment ...
我现在似乎无法查看EM中的包裹......
2 个解决方案
#1
2
You will need to grant some rights to the users which need to run the SSIS packages.
您需要为需要运行SSIS包的用户授予一些权限。
This page should provide the information you need.
此页面应提供您需要的信息。
#2
0
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.
我完全不知道答案,但是从哪里运行SSIS包非常重要。如果我从Visual Studio运行它,它使用我的帐户和权限。如果我将它加载到服务器并且只是尝试直接运行包,那么它正在使用其他东西(并且通常因为我们的服务器设置方式而失败)。如果我从服务器上的作业运行它,它将使用服务器SQA帐户以及该帐户的权限。
#1
2
You will need to grant some rights to the users which need to run the SSIS packages.
您需要为需要运行SSIS包的用户授予一些权限。
This page should provide the information you need.
此页面应提供您需要的信息。
#2
0
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.
我完全不知道答案,但是从哪里运行SSIS包非常重要。如果我从Visual Studio运行它,它使用我的帐户和权限。如果我将它加载到服务器并且只是尝试直接运行包,那么它正在使用其他东西(并且通常因为我们的服务器设置方式而失败)。如果我从服务器上的作业运行它,它将使用服务器SQA帐户以及该帐户的权限。