zip multiple files named by *.csv
Hi, I would like to create a zip file that will zip multiple files named by *.csv from a specified folder. I know we can use Process task to do it. Just do not know how to do it in the command file? ThanksSea Cloud
April 21st, 2011 1:45am

Winzip has a commandline add on: http://www.winzip.com/prodpagecl.htm But it's better (personal opinion) to use a Script Task for it: http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 3:09am

Here is an example of zipping files with a Script Task: http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
April 21st, 2011 3:10am

download a free zip tool like 7zip. then use the process task to use the 7zip command line executable in your installation folder. 7zip has document for command line use.
Free Windows Admin Tool Kit Click here and download it now
April 21st, 2011 4:27am

Hi SeaClould you can find an example here!! http://sqlserversolutions.blogspot.com/2008/10/zip-and-unzip-files-in-folder.html hthRahul Kumar, MCTS, India, http://sqlserversolutions.blogspot.com/
April 21st, 2011 4:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics