CODEWITHSUNDEEP
sql-serverssis
Neo
Neo

Reputation: 16239

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 :(

Upvotes: 5

Views: 2891

Answers (2)

Jesse
Jesse

Reputation: 1

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

Upvotes: 0

Philip Fourie
Philip Fourie

Reputation: 116937

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.

Upvotes: 1

Related Questions