Script task for Zip files - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Script task for Zip files

Author

Topic

RajanThan
Starting Member

7 Posts

Posted - 2012-12-12 : 00:32:15

Hi,

I want to zip an Excel file using script task. Is it possible to zip an Excel file with out any third party tool. your suggestions are appreciated.

Thanks in Advance,
Raj

Rajan

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-12 : 00:47:17

Hi,
You can do by using XP_CMDSHELL and also by using SSIS

Follow these links
http://www.sqlservercentral.com/Forums/Topic970410-148-1.aspx#bm971163
http://microsoft-ssis.blogspot.in/2011/01/zip-sourcefile-to-archive.html
http://www.rafael-salas.com/2008/10/ssis-compress-files-using-execute.html#!/2008/10/ssis-compress-files-using-execute.html

--
Chandu

RajanThan
Starting Member

7 Posts

Posted - 2012-12-12 : 04:07:29

Hi Chandu,

Thanks for your heads up. There is no clear idea to zip a file using ssis script. if possible can you please share some more.

Rajan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources