In this video we will learn how to change the .Net Framework version in Script task from 4 to 4.5. As new class ZipFile is available for us to use in to zip and unzip the files in Microsoft .NET Framework 4.5
You will learn follow Items step by Step
1-How to change .NET Framework version 4 to 4.5 in Script Task when using C# scripting language
2-How to add reference to System.IO.Compression.FileSystem.dll assembly when using C# as scripting language
3-How to use ZipFile class to unzip a zip file and save into a folder.
Code used in the script task
ZipFile.ExtractToDirectory("C:\\Users\\Aamir\\Desktop\\InputFolder\\SourceFile_2015_06_05.zip", "C:\\Users\\Aamir\\Desktop\\InputFolder\\UnZipped");
4- How to change .NET Framework version 4 to 4.5 in Script Task when using Visual Basis scripting language
5- How to add reference to System.IO.Compression.FileSystem.dll assembly when using Visual Basic as scripting language
You will learn follow Items step by Step
1-How to change .NET Framework version 4 to 4.5 in Script Task when using C# scripting language
2-How to add reference to System.IO.Compression.FileSystem.dll assembly when using C# as scripting language
3-How to use ZipFile class to unzip a zip file and save into a folder.
Code used in the script task
ZipFile.ExtractToDirectory("C:\\Users\\Aamir\\Desktop\\InputFolder\\SourceFile_2015_06_05.zip", "C:\\Users\\Aamir\\Desktop\\InputFolder\\UnZipped");
4- How to change .NET Framework version 4 to 4.5 in Script Task when using Visual Basis scripting language
5- How to add reference to System.IO.Compression.FileSystem.dll assembly when using Visual Basic as scripting language
How to solve error Can't find ZipFile class in System.IO.Compression NameSpace in SSIS Script Task
Related Posts/Videos on Zip / UnZip by Script Task
- Load Text Files,Zip them to Folder with Datetime and Delete From Input Directory in SSIS Package
- Extract Files From Zip Files and Delete the Zip Files once Unzipped in SSIS Package
- Load File/s, Zip and Delete from Source Folder in SSIS Package
- Zip ( Compress) Files and Add them to Folder According to Extension in SSIS Package
- Zip or Compress Files according to the Name of Files in SSIS Package
- Get File names from Zip Files and Insert into SQL Server Table in SSIS Package
- How to Zip ( Compress) Multiple Folders and Delete in SSIS Package
- Create Zip file per day with Date Only and Add Files to it in SSIS Package