filmov
tv
SSIS Tutorial Part 134-Extract files from Zip Files & Delete Zip Files once UnZiped in SSIS Package
Показать описание
SSIS Video Scenario:
On daily basis we get zip files those can contain single file or more than one files of different types. We want to create an SSIS Package that can loop through all zip files and extract the files from them and save them to a folder from where we can load them to different destinations in SSIS Package.
In this video we will learn the solution of our given scenario and create an SSIS Package. Below is the list of items we will cover in this video
How to Loop through zip files in SSIS Package
How to create Package Parameters for Zip and UnZip folders and use them in Script Task
How to Change Dot Net Framework from 4 to 4.5 in Script Task
How to add Assemblies such as System.IO.Compression and System.IO.Compression.FileSystem in Script Task
How to Extract Files from Zip file to folder and then delete the zip file in SSIS Package by using Script Task
Blog post link with script for Extract Files from Zip Files
Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
On daily basis we get zip files those can contain single file or more than one files of different types. We want to create an SSIS Package that can loop through all zip files and extract the files from them and save them to a folder from where we can load them to different destinations in SSIS Package.
In this video we will learn the solution of our given scenario and create an SSIS Package. Below is the list of items we will cover in this video
How to Loop through zip files in SSIS Package
How to create Package Parameters for Zip and UnZip folders and use them in Script Task
How to Change Dot Net Framework from 4 to 4.5 in Script Task
How to add Assemblies such as System.IO.Compression and System.IO.Compression.FileSystem in Script Task
How to Extract Files from Zip file to folder and then delete the zip file in SSIS Package by using Script Task
Blog post link with script for Extract Files from Zip Files
Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers
Комментарии