Access拒绝将SSIS包作为作业运行 [英] Access Denied running SSIS package as a Job

问题描述

大家好，

我在服务器2010上创建了一个ssis packge，它在本地系统中工作正常。但我在ssis中将文件移动到文件服务器我遇到了ssis包的问题是accessDenaied。

请告诉我。

Hi All,
I have created a ssis packge on sever 2010 it is working fine in local system.but i moved file to fileserver in ssis i got a problem with ssis package is accessDenaied.
Please let me know .

推荐答案

检查SQL Server服务帐户的权限（用户执行作业）......

您也可以创建代理（使用您的帐户）来执行作业。为此，您需要先添加凭据，然后创建代理，谷歌创建凭据/代理将为您提供详细步骤

Check permissions of the SQL Server Service Account(the user executes job)...
You can create proxies (with your account) to execute the job also. For this you need to add Credentials first, then create Proxies, google on creating credentials/proxies will get you detail steps

这篇关于Access拒绝将SSIS包作为作业运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！