FTP任务错误：无法锁定变量SSIS [英] Error at FTP Task: Failed to lock variable SSIS

问题描述

我已经定义了以下变量：

remotePath = /

localPath = c：\downloads

fileMask = * .txt

在FTP任务编辑器中，我为remotePath创建了表达式，如

remotePath = @ [User :: remotePath] + @ [User :: fileMask]正确评估到/ *。txt

我已将IsRemotePathVariable设置为True。

IsLocalPathVariable为True

LocalVariable为User :: localPath

当我运行这个软件包，我收到一个错误消息。

FTP错误：任务：无法锁定变量/*.txt / b>

解决方案

我知道这是旧的，但可能有助于其他人：
我在Message中设置了MessageSource表达式设置
我通过删除Mail se来修复它并将类型更改为直接输入。

I am trying to FTP receive multiple files *.txt from a remote server's root directory.

I have defined the following variables

remotePath = /

localPath = c:\downloads

fileMask = *.txt

In the FTP Task editor, I have created expression for remotePath, as in

remotePath = @[User::remotePath] + @[User::fileMask] which evaluates correctly to /*.txt

I have set IsRemotePathVariable to True.

IsLocalPathVariable to True

LocalVariable to User::localPath

When I run this package, I am getting an error.

Error at FTP Task: Failed to lock variable "/*.txt" for read access with error ....

解决方案

I know this is old, but may help someone else: I had the MessageSource set in both the Email and Expression settings I fixed it by removing the Mail setting and change the type to Direct Input.

这篇关于FTP任务错误：无法锁定变量SSIS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！