How to zip files using winzip in ssis with execute process task..
Hi
can any body explain me how to zip files in folder using ssis execute process task...
please explain me execution process task configuration task step by step
say i have some files in "C:\test1\"
and i want them to zip and name as "zippedtestfiles.zip"
and i want the zip file in "C:\Test2\" folder
what are the configuration steps
executable:
Arguments:
workingDirectory:
Thanks & Regards $@m
April 22nd, 2012 2:27pm
Hi $@m,
Search this forum or look the Related Topics on the right site... very common question.
For example:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/278e691c-45ac-4c92-9193-67999e4be7fd
And the first answer from aunt Google:
http://www.rafael-salas.com/2008/10/ssis-compress-files-using-execute.html
Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2012 2:38pm
Hi Joost
Thanks for ur reply...
links you have provided are works for extracting zip files but my requirement is archiving files into zip....
i have tried out this task... i got it by configuring as following settings
executable: c:\<fullpath>\winzip32.exe
Arguments: a <sample name for ur zip file> "<Fullpath of source files>"
workingDirectory: "<Full path of the directory where you want to save the zip file....>"
it have worked for me...
Thanks & Regards $@m
April 23rd, 2012 1:51am
zipping or unzipping... same solution... just other
product specific arguments.Please mark the post as answered if it answers your question | My SSIS Blog:
http://microsoft-ssis.blogspot.com |
Twitter
Free Windows Admin Tool Kit Click here and download it now
April 23rd, 2012 2:27am