Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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 Task] Error: Directory is not specified in the file connection manager "User::ProcessingFileLocation"

In FTP Editor setting :

User::ProcessingFileLocation used SSIS variable

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

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

like image 465
Neo Avatar asked Nov 14 '22 01:11

Neo


1 Answers

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.

like image 153
Philip Fourie Avatar answered May 01 '23 18:05

Philip Fourie