ZIP excel file in SSIS 2008

• pujain

  SSCrazy

  Points: 2903

  More actions

  August 17, 2010 at 7:42 am

  #157152

  Hi,

  can anybody explain me how can i zip excel file in SSIS package?

  thanks

  Puneet

• Tim Mitchell

  SSCoach

  Points: 15681

  More actions

  August 17, 2010 at 8:02 pm

  #1208233

  This should help:

  http://www.rafael-salas.com/2008/10/ssis-compress-files-using-execute.html

  Tim Mitchell, Microsoft Data Platform MVP
  Data Warehouse and ETL Consultant
  TimMitchell.net | @Tim_Mitchell | Tyleris.com
  ETL Best Practices

• pujain

  SSCrazy

  Points: 2903

  More actions

  August 18, 2010 at 1:05 am

  #1208326

  thanks Tim, it worked.

• Lonely Rogue

  SSCrazy

  Points: 2579

  More actions

  August 18, 2010 at 8:14 am

  #1208510

  @pujain

  I too Compress and UnCompress the Zip files thru SSIS using Execute SQL Task...perhaps you can try this as an alternative....

  Add the below code in SQL Statement of Execute SQL Task

  XP_CMDSHELL 'C:\Progra~1\WinZip\Winzip32 -min -e "E:\Reports.Zip" "E:\Reports"'

  WinZip32 is the Exe located in that folder. This -e switch command is to UnZip; -a is to add files to Zip.

  I dont know if there can be any performance impact of side-effects of executing a Exe in this way than using "Execute Process Task". But this way, you can embed this code in job or any T-SQL scripts.

  I have attached the Command-Line reference for WinZip exec.

  Check out and Post your comments/observations.

  In 'Thoughts',

  LonelyRogue.

  --In 'thoughts'...
  Lonely Rogue

• lijnenjoost

  Right there with Babe

  Points: 767

  More actions

  January 8, 2011 at 4:15 am

  #1271039

  Use a Script Task if you'r a little bit familiar with .net:

  http://microsoft-ssis.blogspot.com/2011/01/zip-sourcefile-to-archive.html

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 14, 2011 at 12:27 pm

  #1273735

  pujain (8/17/2010)

  ---

  Hi,

  can anybody explain me how can i zip excel file in SSIS package?

  thanks

  Puneet

  Puneet,

  If you can use third-party solutions, check the commercial CozyRoc Zip Task. It is completely integrated inside SSIS.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/