How to Zip/Unzip Files in SSIS - Need Compression Task

Question

Hi anyone can suggest best Zip/Unzip Task for SSIS. We want to zip several GB files.

I just found a product called TaskFactory looks very promising but wondering if anyone used it http://www.pragmaticworks.com/Products/Business-Intelligence/Taskfactory

Thanks

Answer 1

You could use a script task to and use .NET to zip files within the control flow of your package. You can use the built in class gzip (gzip) or you can use this free class library from codeplex which I heard works well called dotnetzip (dotnetzip)