服务器上下文中的SSIS变量更改 [英] SSIS Variables changing in the context of server

问题描述

我有一个SSIS作业，该作业从输入的FTP目录中获取文件并将内容解压缩到temp目录中，以进行进一步处理.我在输入的FTP目录上使用For-Each目录循环，并且在其中循环调用Winzip.使用SSIS表达式构建器使用输入文件的文件名和临时目录的名称配置命令行调用的参数.在Expression Builder中看起来像这样:

I have an SSIS job which takes files from an input FTP directory and unzips the contents into a temp directory for further processing. I''m using a For-Each directory loop over the input FTP directory, and within that there is a call to Winzip. The argument to the command-line call is configured with the filename of the input file and the name of the temp directory using the SSIS Expression builder. It looks like this in Expression Builder:

" -e  " +  @[User::InputFolder] + "\\" + @[User::CurrentInputFileName] + "  " + @[User::TempFolder]

现在，当我从VS2005在本地运行并通过网络访问相关文件时，所有这些工作正常且繁琐.但是，当我部署到应用程序服务器时，我从另一端看不到任何东西.它只是挂在那里.这些变量似乎一直在丢失.

有任何想法吗?

Now, this all works fine and dandy when I run it locally from VS2005 and access the relevant files over the network. But when I deploy to the application server, I get nothing out of the other side; it just hangs there. The variables seem to be being lost along the way.

Any ideas anyone? Has anyone seen similar behaviour from an SSIS package?

推荐答案

原来是服务器上的NT权限问题.

Turned out to be an NT permissions issue on the server.

这篇关于服务器上下文中的SSIS变量更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！