Vision Binary

Recently, one of my clients asked me to create an SSIS package that will accomplish these tasks.

1. Connect to FTP site and download multiple zip files using wild card string
2. Unzip the files into a folder
3. Read through each file and import the data into a database table
4. Archive the files into another folder

Step 0: Setup the variables.

Here is a screenshot of the variables that I am using. I have BIDS Helper installed, so you will notice the pink icons for the variables that are dynamic. 

Step 1: Download files from FTP site
This one is pretty easy. 

1. Create an FTP connection in the connection managers
2. Drag/Drop and the FTP task onto the control flow in SSIS.
3. Create 2 variables:
FolderDestination – this is the folder destination where the files will end up after downloading
FTPFullPath – put in name of file…