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  



10 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
  4. replica rolex watches uk, combining elegant style and cutting-edge technology, a variety of styles of replica rolex milgauss watches, the pointer walks between your exclusive taste style.

    ReplyDelete
  5. Awesome blog thankks for sharing 100% virgin Remy Hair Extension in USA, importing from India. Premium and original human hair without joints and bondings. Available in Wigs, Frontal, Wavy, Closure, Bundle, Curly, straight and customized color hairstyles Extensions.

    ReplyDelete
  6. Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.

    ReplyDelete
  7. Spot on with this write-up, I actually believe this website needs far more attention. I’ll probably be returning to see more, thanks for the information!
    Click here to get More information.

    ReplyDelete
  8. In data science some analysis is done to discover insights from the data and also predictions can be done with the help of many machine learning algorithms. machine learning institute in hyderabad

    ReplyDelete