SSIS Tutorial Part 140-Create Zip file per day by using Date and Add Files to it in SSIS Package

SSIS Video Scenario:

We get multiple files during a day and night. we have scheduled to run our SSIS Package every hour. We want to create a Zip file per day and then keep adding the files to it after loading in the same day. Next day a new Zip file should be automatically created and files should be copied to that after loading.

Solution:

In this video we will learn the solution for our scenario " How to Create A Zip File with Date Per day and add files to it after loading in SSIS Package". Below are the list of items we will learn in this video

How to Create Package Parameters for InputFolder and ArchFolder so we can change the values of them according to the environment ( QA, UAT, Prod) and we don't have to make any changes in the SSIS Package.
How to use Foreach Loop Container to look through files in SSIS Package
Save File name in FileName Variable From Foreacah Loop Container
How to Change .NET Framework 4 to 4.5
How to add reference to Assemblies such as System.IO.Compression and System.IO.Compression.FileSystem
Create empty Zip File by using Script Task
Add file to Zip file by using Script task in SSIS Package

Load Files and Then Zip to File with Date for everyday- link to the post for scripts used in the video

Step by Step SSIS Tutorial by Tech Brothers

[deepakahirwar]

Hello Dear, Aamir Sir : We are lucky to have such tutorials .You explained it so perfectly. Providing all materials to practice the programs. Much Metta!

[tommydobrzanski]

Thanks. Great explanation! Best one I've watched so far re script for zipping files.
Question though, what would you change in a variable or in the actual script to name the a zip file according to its original files name? so in your example the result would be
Customer_20140507.txt.zip and Customer_20140506.txt.zip. Thanks for any points!!