部署的SSIS包未在另一台计算机上运行 [英] Deployed SSIS Package not running in another machine

问题描述

朋友们...

我创建了一个新的SSIS程序包，并将其部署在服务器中.当我通过sql服务器管理工​​作室在我的计算机上运行该程序包时，它可以成功运行.现在，问题出在我连接了sql服务器管理的另一台计算机上工作室到同一台服务器并连接到集成服务..我可以看到保存的包，但是当我单击执行"按钮时，消息显示访问被拒绝，因为错误代码为0x……这是什么问题.如果是权限问题或其他问题?

Hi frnds...

I created a new SSIS Package and deployed the same in the server.. it works successfully when i run the package in my machine through sql server management studio.... Now, what the problem is on another machine i connected the sql server management studio to the same server and connected to integration services.. I can saw the saved package but when i click execute button the message displays the access is denied because of the error code 0x...... what the problem is this... IF it is a permission problem or something else??

推荐答案

这似乎是权限问题.您正在使用Package中的Remote Path或anather驱动器吗?如果是，那么该用户对该驱动器具有访问权限吗?

看看给定的线程.
http://social.msdn.microsoft.com/Forums/zh/sqlintegrationservices/thread/9cde6bda-6219-4f5a-be28-5208281394b8 [

It seems like permission issue. Are you using Remote Path or anather drive in Package? If yes then is that user has access rights on those drive?

Have a look at given thread.
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/9cde6bda-6219-4f5a-be28-5208281394b8[^]

这篇关于部署的SSIS包未在另一台计算机上运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！