1

I am trying to download data files from a FTP server to local machine through SSIS. But it throws the error

Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager".

I have even explored all the articles regarding it and even changed the protection level to all the types, but none seems to be working. Please do help me. Attached screenshots shall help you.

Connection manager settings

Error while connecting

FTP task settings

WinSCP Tool

Martin Prikryl
  • 7,327
  • 2
  • 36
  • 71
Alekhya varma
  • 11
  • 1

1 Answers1

0

You are connecting using SFTP protocol in WinSCP.

FTP and SFTP are two completely different protocols. You cannot expect that you can use an FTP client (SSIS FTP Task) and it will connect to SFTP server, if you change a port to 22. It won't.

SSIS does not support SFTP. You have to use a 3rd party solution. WinSCP can be used to implement SFTP in SSIS:

Martin Prikryl
  • 7,327
  • 2
  • 36
  • 71
  • Thank you for your support in making me understand about connecting to SFTP server through FTP client. Tried your method and every possible way. But couldn't perhaps its our firewall issue. Finally implemented .net script code shared by my colleagues. – Alekhya varma Sep 13 '19 at 02:26