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