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  



4 comments:

  1. Great blog thanks for sharing Instagram and Facebook have provided an amazing place for new brands to grow and flourish. We can find the perfect niche for your brand on the best social media marketing in chennai. Marketing through social media brings forth global audience without all these physical boundaries.

    ReplyDelete
  2. Nice blog thanks for sharing Run your salon business successfully by tying up with the best beauty shop in Chennai - The Pixies Beauty Shop. With tons of prestigious brands to choose from, and amazing offers we’ll have you amazed.

    ReplyDelete
  3. Excellent blog thanks for sharing Choosing the right place to buy your first plant isn’t that hard of a choice anymore. Presenting the best plant nursery in Chennai - Karuna Nursery Gardens is proud to showcase more than 3000+ plants ready to be chosen from.

    ReplyDelete