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 :(
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With