FTP任务错误:无法锁定变量SSIS(Error at FTP Task: Failed to lock variable SSIS)

其他开发 IT屋
问 题

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.

本文地址:IT屋 » 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来修复它并将类型更改为直接输入。


本文地址:IT屋 » FTP任务错误:无法锁定变量SSIS