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

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

Other recent topics Other recent topics