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