运行SSIS包远程的问题 [英] Issues running SSIS package remote

问题描述

大家好，

我有一个SSIS包，直接登录到Windows数据库服务器时运行正常。

I have an SSIS package that runs fine when logged in directly to the Windows database server.

I我正在运行Windows 2016 Server和SQL Server 2016。

I am running Windows 2016 Server and SQL Server 2016.

但是，如果我尝试使用SSMS从我的Windows PC远程运行相同的SSIS包，则它将无法启用"无法写入数据文件"。错误。

However, if I try to run the same SSIS package remote from my Windows PC with SSMS, it fails on "cannot write data file" errors.

OLE错误：无法打开数据文件" \\myshare \ssis\staging "

OLE error: cannot open the data file "\\myshare\ssis\staging"

这很奇怪，因为我的用户帐户具有完全权限等等。我可以检查什么来解决这个问题，以便我可以在我的PC上从SSMS远程运行SSIS包？

This is weird because my user account has full privileges and so forth. What can I check to solve this issue so that I can get the SSIS package to run remote from SSMS on my PC?

推荐答案

你好sacdba，

Hi sacdba,

似乎错误消息中缺少实际文件名。

It seems that the actual file name is missing in the error message.

当您运行SSIS包时，是否可能在服务器上的问题，一些
参数被传递？

Is it possible that when you are running the SSIS package in question on the server some parameters are passed?

这篇关于运行SSIS包远程的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！