ZIP excel file in SSIS 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » ZIP excel file in SSIS 2008

ZIP excel file in SSIS 2008

Rate Topic

Display Mode

Topic Options

Author

Message

pujain

Posted Tuesday, August 17, 2010 7:42 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:00 AM
Points: 268, Visits: 188

Hi,

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

thanks
Puneet

Post #970410

Tim Mitchell

Posted Tuesday, August 17, 2010 8:02 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593

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

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell

Post #970835

pujain

Posted Wednesday, August 18, 2010 1:05 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:00 AM
Points: 268, Visits: 188

thanks Tim, it worked.

Post #970948

Lonely Rogue

Posted Wednesday, August 18, 2010 8:14 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 3:34 AM
Points: 165, Visits: 405

@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

Post Attachments

WinZip Command Line Parameters.zip (34 views, 2.42 KB)

Post #971163

lijnenjoost

Posted Saturday, January 08, 2011 4:14 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 11:59 PM
Points: 22, Visits: 184

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

Post #1044858

CozyRoc

Posted Friday, January 14, 2011 12:27 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:59 PM
Points: 1,106, Visits: 2,113

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/

Post #1048131

« Prev Topic | Next Topic »

Permissions