How to Change .Net Framework Version in SSIS Package and Add Assembly Reference ( ZipFile) - SQL Server Integration Services(SSIS) Tutorial

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



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