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

最新推荐文章于 2021-04-13 06:00:18 发布

原创最新推荐文章于 2021-04-13 06:00:18 发布 · 1w 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#bug #SSIS

TEL-Tool-SSIS 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了在SQL Server Integration Services (SSIS)中配置FTP任务的过程，特别关注如何正确设置远程路径变量，以实现文件从一个FTP服务器到本地再至另一个FTP服务器的传输。文章还提供了遇到“变量不以‘/’开头”错误时的解决方案。

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.