Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ZIP excel file in SSIS 2008 Expand / Collapse
Author
Message
Posted Tuesday, August 17, 2010 7:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:22 AM
Points: 298, Visits: 230
Hi,

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

thanks
Puneet
Post #970410
Posted Tuesday, August 17, 2010 8:02 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:41 AM
Points: 1,042, Visits: 2,714
This should help:
http://www.rafael-salas.com/2008/10/ssis-compress-files-using-execute.html




Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #970835
Posted Wednesday, August 18, 2010 1:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:22 AM
Points: 298, Visits: 230
thanks Tim, it worked.
Post #970948
Posted Wednesday, August 18, 2010 8:14 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 10:31 PM
Points: 167, Visits: 409
@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 (39 views, 2.42 KB)
Post #971163
Posted Saturday, January 8, 2011 4:14 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:38 AM
Points: 23, Visits: 206
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
Posted Friday, January 14, 2011 12:27 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
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 »

Add to briefcase

Permissions Expand / Collapse