I have a requirement where I will be receiving multiple flat files in a folder, I need to create 1 zip file and drop it into another folder. How can I achieve this us

Hello,

Try the following article to create the compressed file.

https://dataintegrity.wordpress.com/2009/10/13/dynamically-zipping-files-in-ssis/

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

About moving the ZIP file to another folder/location, please read the following article:

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html   


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 10 hours 52 minutes ago

why is that we are using 7zip another tool to create zip file...is there no direct way of creating zip files directly using out of box SSIS tools ?

Hello,

Try the following article to create the compressed file.

https://dataintegrity.wordpress.com/2009/10/13/dynamically-zipping-files-in-ssis/

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

About moving the ZIP file to another folder/location, please read the following article:

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html   


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Thursday, July 23, 2015 8:14 PM

Hello,

Try the following article to create the compressed file.

https://dataintegrity.wordpress.com/2009/10/13/dynamically-zipping-files-in-ssis/

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64028/

About moving the ZIP file to another folder/location, please read the following article:

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html   


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Thursday, July 23, 2015 8:14 PM

Hi MBH,

There is no built-in task to directly zip files or unzip files in SQL Server Integration Services. So we need make use of other tools out of SSIS to work around the issue.

To achieve your requirement, we can use Execute Process Task with 7-ZIP and File System Task as Alberto said. Or we can use a custom task that can do compression and decompression of Zip, for example, Zip Task.

Thanks,
Katherine Xiong

my Production servers do not have 7zip installed, and the business is hesitating to install 3rd party tools on the server. Apart from this, is there a way to zip files using SSIS ?

Hi MBH,

There is no built-in task to directly zip files or unzip files in SQL Server Integration Services. So we need make use of other tools (7zip, WinRAR or others) out of SSIS to work around the issue.

Thanks,
Katherine Xiong

I have got the permission to install 7zip on my machine.

1)  can anyone send me a valid not virus 7zip exe to download and install.

2)  step by step description of flow task and setting the properties to achieve this ? i.e taking 5 different files from a folder and zipping them in 1 folder ?

Hi MBH,

Please refer to the following blogs:
http://www.techbrothersit.com/2013/12/ssis-how-to-compress-and-archive-file.html
http://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.html

Thanks,
Katherine Xiong

Hi,

You can take a look into this post, By using this you can create a zip file and then add files to it, After adding all the files you can move that zip file to another folder.

http://www.techbrothersit.com/2015/06/create-zip-file-with-date-and-keep.html

after zipping that multiple files in 1 zip folder, I need to delete the files from source folder location too, how is this achievable ?

Hi MBH,

To delete the files from source folder location, we can use File System Task in SSIS. For more details, please see:
http://www.tutorialgateway.org/delete-directory-content-using-file-system-task-in-ssis/

Thanks,
Katherine Xiong

So how can this be everything in 1 SSIS package ? 1) creating source folder pointing to folder holding multiple txt files 2) Archieve folder - that creates 1 zip file of this multiple files on daily basis. 3) delete multiple files from source folder ?? 4) and how can this be dynamically achievec in setting in all environment like dev, UAT, Prod