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