I am trying to run a SSIS package on Server1 which goes and downloads a XML file from a FTPS server. This XML file is actually encoded and carries data which are to be moved to the database in Server1.
When I run the SSIS package I receive the following error: Error: The script threw an exception: The remote server returned an error: 227 Entering Passive Mode (192,168,0,39,11,186) Task Download Dataupdate file from FTPS server failed
Any idea on what could be the reason behind this error?
Note: I am directly running the SSIS package when I am logged into the server1.
This error message was because of the firewall issue. There was a firewall which was assuming that the encrypted xml file was harmful and so blocked download of it to the server.