Zip or Compress Files according to the Name of Files in SSIS Package
We have one Source folder in which everybody puts the files to load. There are Customer Files those start with Customer_Date_Time, There are Sales files with Sales_DateTime etc. We want to create an SSIS Package that can run at the end of the day and zip the files according to the names of the files.
Solution:
In this video you will learn following items
Create Package Parameters for SourceFolder and ArchFolder so the path can be changed by using SSIS configuration according to the environment
Create FileName variable so we can save file name with extension when loop through files by using Foreach Loop Container
Create ZipFile Variable and write expression to build Full Zip File path
Change .Net Framework to 4.5 version in script task so we can add assemblies such as System.IO.Compression and System.IO.Compression.FileSystem
Write Script to Create new Zip file if not exists according to name part and date. Then add the file to it and delete the file from source folder.
If zip file already exists then add the file to it and delete the source file from Source Folder.
link to the scripts used in the video : Zip Files according to the name in SSIS Package
sqlage.blogspot...
Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
www.techbrother...
6 сен 2024
