FTP Task error in SQL Server SSIS Package.

  • Article

If you have created a SSIS Package in SQL Server and you use a FTP Task to upload a file to a FTP server and encounter the error "An error occurred in the requested FTP operation. Detailed error description: 200 Switching to Binary mode. 553 Could not create file" then you are not alone!

Even though the error message itself leaves you clueless, the solution is very simple! Just set the 'Remote Path' property of your FTP Task to "/". That's it - just setting the remote path to / will solve your problem and will take your troubles away.

Enjoy,
Paras