在SSIS包中运行作业时拒绝访问 [英] Access denied while running job in SSIS packages

问题描述

大家好，



我已将软件包导出到CSV文件，并且在本地计算机上工作正常。当我遇到工作时，我收到的错误就像是拒绝访问。

可能是什么原因？



请帮忙。

解决方案

您好，



您需要创建SQL代理帐户，并确保使用凭据谁有权运行您的SSIS ETL包。



http://www.avastonetech.com/Library/Library/Blogs/Programming.aspx?post=Executing+a+SQL+Server+Integration+Services+Package+ +集成+服务+包+来自+ a +网站





如果您有任何问题，请使用上述参考资料并告诉我。

Hi all,

I had exported package to CSV file and It's working fine in local machine. When ever running through job, I'm getting an error like 'Access denied'.
what could be the reason?

Please help.

解决方案

Hi,

You need to create SQL Proxy Account, and make sure to use credentials in that who has permission to run your SSIS ETL package.

http://www.avastonetech.com/Library/Library/Blogs/Programming.aspx?post=Executing+a+SQL+Server+Integration+Services+Package+from+a+Website


Please use above reference and let me know if you have any issue.

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