How to download file using ftp script task in SSIS?

Question

I want SSIS script task where we can login into mainframe using ftp command and then download it using get command. I have ServerName, UserName, Password, FileName.

Currently I use command prompt to download the file with commands:

1. Open command prompt
2. Type -- ftp ServerName
3. UserName
4. PassWord
5. get 'FileName' "C:\temp\file1.csv"

Or a .bat file script also work where we run that bat file and file could be downloaded automatically.

Answer 1

Please check this tutorial:

https://www.mssqltips.com/sqlservertip/1641/get-list-of-files-from-an-ftp-server-in-sql-server-integration-services/

and for the official documentation about using FTP Task in SSIS, you can check this:

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/ftp-task?view=sql-server-ver16&WT.mc_id=DP-MVP-5001699

Answer 2

Hi @Gaurav Singh,

You may use FTP Task in SSIS to achieve this. And then you may schedule the package to be automatically.

Check: SSIS - How to Use FTP Task [Download File from FTP Site]

If you want to use script task, take a look at the examples here.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.