Tuesday, April 23, 2013
SSIS : 200 Type set to A.500 PORT/EPRT (Active Mode/Extended Active Mode) is not supported. Use PASV/EPSV instead of this
I was working on one SSIS package , in which I need to use FTP task to get some files from the remote server. For that I need to createa FTP connection in connection manager. But when I was executing the package it was getting stop at FTP task, and was throwing error as I mentioned above.
I checked FTP connection manager 10 times , but I was not getting any solution for this, then I see the ‘Use Passive Mode’ checkbox, which was unchecked in the FTP connection manager. So I checked the checkbox ‘UsePassive Mode’ in the FTP connection manager. It worked and the error was gone.