SSIS包FTP任务错误:文件连接管理器“User :: ProcessingFileLocation”中未指定目录

时间:2021-07-25 19:41:07

I have one SSIS package that has FTP task which takes files from FTP and save on my local drive but i'm getting this error:

我有一个具有FTP任务的SSIS包,它从FTP获取文件并保存在我的本地驱动器上,但是我收到此错误:

[FTP Task] Error: Directory is not specified in the file connection manager "User::ProcessingFileLocation"

[FTP任务]错误:文件连接管理器“User :: ProcessingFileLocation”中未指定目录

In FTP Editor setting :

在FTP编辑器设置中:

User::ProcessingFileLocation used SSIS variable

User :: ProcessingFileLocation使用SSIS变量

Values sets to this is \\MYSERVER\\Raw Data\\

设置为的值是\\ MYSERVER \\ Raw Data \\

Why getting this error any solution When i mention direct path it is working fine but having error with variable :(

为什么得到这个错误任何解决方案当我提到直接路径它工作正常,但有变量错误:(

2 个解决方案

#1


1  

Another solution to this problem might be the one that affected me.

这个问题的另一个解决方案可能是影响我的问题。

The FTP task does not create the path specified in the LocalVariable, make sure to manually create the destination folders.

FTP任务不会创建LocalVariable中指定的路径,请确保手动创建目标文件夹。

#2


0  

override the UNC path with local path in Integration Services Catalog, connection manager. Right click on the project and choose configure

在Integration Services Catalog,连接管理器中使用本地路径覆盖UNC路径。右键单击项目,然后选择configure

#1


1  

Another solution to this problem might be the one that affected me.

这个问题的另一个解决方案可能是影响我的问题。

The FTP task does not create the path specified in the LocalVariable, make sure to manually create the destination folders.

FTP任务不会创建LocalVariable中指定的路径,请确保手动创建目标文件夹。

#2


0  

override the UNC path with local path in Integration Services Catalog, connection manager. Right click on the project and choose configure

在Integration Services Catalog,连接管理器中使用本地路径覆盖UNC路径。右键单击项目,然后选择configure