The ZIP file task is a great feature that SSIS has for when you need to move/email a large amount of data. Also if you have multiple files you want to move to the same location, this makes it easier for you, so you can move just one file instead of many.

I prefer to use variables which I can change if the location changes over using hard-coded values. The first step is to create the variables on the package:

Next step is to place the Zip task in your Control Flow area. Then configure it as follows:

This will then compress and zip your files in the source you set. You can then use a Process System task to move this file to where you require it or use an email task to email the file to people.

One thought on “Using a ZIP Task in SSIS

  1. Can’t find this task in the SSIS Toolbox. We are using SSDT-BI 2017. Would you know how/where I can find it? Is this out of the box?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.