Zip and Unzip files using Activex

Question

Zip and Unzip files using Activex

pinky

SSCommitted

Points: 1997
More actions
April 25, 2006 at 11:44 am

#169236

Hi,
I need an ACTIVE X script to Zip and Unzip the files. I will be getting files in a Zipped folder, i need to Unzip those. Can anyone please let me know as to how to do that. Thanks for your help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

DanKennedy Hall of Fame Points: 3736 More actions · Answer 1

Firstly you need a zip product that allows you to automate it via script, either through automation (COM) or through the command line (shell). Winzip has a command line executable that you could call via a windows scripting host shell. I'm sure there are other compression utilities that also allow you to shell out but I can't think of any at the moment.

Your other alternative, depending on your programming environment/experience is to use a library such as ICSharpCode.SharpZipLib and wrap it in a custom .net (possibly COM interoperable) wrapper and call that instead.

Dan
www.firstcs.co.uk

philcart SSC-Forever Points: 47795 More actions · Answer 2

I'd just use something like GZip and call it via WScript.Shell in the ActiveXScript task.

Much, much easier.

--------------------
Colt 45 - the original point and click interface

Rob v Dijk SSC Enthusiast Points: 163 More actions · Answer 3

I made a simple procedure some time ago which does what you are looking for.

ALTER PROCEDURE sp_Unzip (@SourceDir VARCHAR(100), @DestinationDir VARCHAR(100), @ZipFile VARCHAR(100))

AS

-- DECLARE @SourceDir VARCHAR(100), @DestinationDir VARCHAR(100), @ZipFile VARCHAR(100)

-- SET @SourceDir = 'd:\'

-- SET @DestinationDir = ''

-- SET @ZipFile = 'unzip.zip'

IF @DestinationDir = ''

SET @DestinationDir = @SourceDir

DECLARE @StrSQLUnzip NVARCHAR(1000)

--DECLARE @StrSQLRemoveZip NVARCHAR(1000)

SET @StrSQLUnzip = 'EXEC master..xp_cmdshell ' + '''' + 'wzunzip -o ' + @SourceDir + @ZipFile + ' ' +@DestinationDir +''''

--SET @StrSQLRemoveZip = 'EXEC master..xp_cmdshell ' + '''' + 'DEL '+ @SourceDir + @ZipFile +''''

EXEC (@StrSQLUnzip)

--EXEC (@StrSQLRemoveZip)

Hans Lindgren SSChampion Points: 10496 More actions · Answer 4

I would just point out that ICSharpCode.SharpZipLib, as of writing time, has a nasty drawback; ICSharpCode.SharpZipLib does not support any files greater then 4GB.