SSIS异常--SSIS FTP Task Variable Remote Path invalid

来源:互联网 发布:域名贴吧 编辑:程序博客网 时间:2024/05/18 17:59

I am working on the SSIS FTP Task that transfer file from one FTP server to local location, rename the file name, and finally transfer the renamed file to another FTP server. So I defined 2 FTP tasks.

For the FTP file receive operation, I need the remote path to be updated by a script and pass to the user define variable. So I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPSourcePath where the variable is set in the script with "/DMFTP/filename1.jpg"

For the FTP file send operation, I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPDestPath where the variable is set in the script with "/DestFTP/"

After all the setting, the FTP Task box show me the error as "Variable "FTPSourcePath" doesn't start with "/". Another FTP box show me "Variable "FTPDestPath" doesn't start with "/"

Can anyone help me on this problem?? Thanks.

意思在使用SSIS,FTP组件在设置远程参数的时候出现参数不能为空的提示。

解决办法为

Since you set the variable in a script task, and the value is only available during execution - set DelayValidation property of the FTP task to true.

原创粉丝点击