August 17, 2010 at 7:42 am
Hi,
can anybody explain me how can i zip excel file in SSIS package?
thanks
Puneet
August 17, 2010 at 8:02 pm
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
August 18, 2010 at 1:05 am
thanks Tim, it worked.
August 18, 2010 at 8:14 am
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
January 8, 2011 at 4:15 am
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
January 14, 2011 at 12:27 pm
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply