SSIS package FTP request error: directory not specified in the file connection manager "User :: ProcessingFileLocation"

Question

I have one SSIS package with an FTP task that takes files from FTP and saves to my local drive, but I get this error:

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

In the settings of the FTP editor:

User::ProcessingFileLocation using the SSIS variable

Values on this: \\MYSERVER\\Raw Data\\

Why this error is needed for any solution. When I mention the direct path, it works fine, but has an error with a variable :(

+4

Neo Jul 18 '12 at 16:55

2 answers

Override the UNC path using the local path in the Integration Services directory, Connection Manager. Right click on the project and select configure

0

Jesse Jul 25 '17 at 17:15

Philip fourie · Accepted Answer · 2016-08-22T14:45:41+0000

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

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