Downloading files from ftp site which are stored in .zip folder

Question

Hi,

I have a requirement where i have to load the file from ftp site to my local folder. Files are in .zip folder and there are many .zip folders but we have to load file from the latest folder. What is the best way to achieve this in SSIS?

Thanks

Syed Faiz

Answer 1

Hello Syed,

With FTP you can only download the complete ZIP file to your local disk; there you can unzip the file to get the content; it's not possible to extract single file from a ZIP via FTP.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Hi Syed,

Here are few links those can help you to start

1) Download the files form FTP To local

Sync FTP Folder to Local Folder without Downloading Existing Files by using Script Task in SSIS Package

2) If you want to keep downloading all the files to local folder and don't want to move them to archive folder after loading, you can get the latest file by using below

How To Get Most Recent File from Directory And Load To a Table

3) Unzip the file

How To Unzip .Zip Files In SSIS [ How To Use Execute Process Task In SSIS ]

---

Good Luck!


TechBrothersIT.com

Answer 3

On the FTP server, create a subfolder (i.e., Processed) under the download folder. When the zip file is downloaded move the file to Processed.

---

A Fan of SSIS, SSRS and SSAS