(SQL Server) Control Stored ZIP Paths Using AppendFromDir

See more Zip Examples

This example demonstrates how to use the AppendFromDir property to control which portion of a local filesystem path is stored within a ZIP archive.

When files are added using methods such as AppendFiles, AppendFilesEx, or AddFile, the stored ZIP path is determined relative to the AppendFromDir directory.

This property is especially useful when:

• Creating ZIP archives with clean relative paths
• Excluding unwanted leading directory portions from ZIP entries
• Packaging projects or directory trees while preserving selected relative path information

Suppose the local filesystem contains:

c:/abc/123/myAppDir/readme.txt
c:/abc/123/myAppDir/config/settings.json
c:/abc/123/myAppDir/images/logo.png

And suppose:

zip.AppendFromDir = "c:/abc/123";

Then the following call:

zip.AppendFiles("c:/abc/123/myAppDir/*",1);

Will store these paths in the ZIP archive:

myAppDir/readme.txt
myAppDir/config/settings.json
myAppDir/images/logo.png

Without AppendFromDir, the ZIP archive paths would instead begin relative to the append root:

readme.txt
config/settings.json
images/logo.png

The AppendFromDir property affects subsequently added filesystem entries.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @zip int
    EXEC @hr = sp_OACreate 'Chilkat.Zip', @zip OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Create a new ZIP archive.
    EXEC sp_OAMethod @zip, 'NewZip', @success OUT, 'myApp.zip'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @zip, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @zip
        RETURN
      END

    -- Set the AppendFromDir property.
    -- 
    -- Paths stored in the ZIP archive will be relative to:
    -- 
    --     c:/abc/123
    -- 
    EXEC sp_OASetProperty @zip, 'AppendFromDir', 'c:/abc/123'

    -- Recursively add files beneath:
    -- 
    --     c:/abc/123/myAppDir
    -- 
    -- Because AppendFromDir = "c:/abc/123",
    -- the ZIP paths will begin with:
    -- 
    --     myAppDir/
    -- 
    DECLARE @recurse int
    SELECT @recurse = 1
    EXEC sp_OAMethod @zip, 'AppendFiles', @success OUT, 'c:/abc/123/myAppDir/*', @recurse

    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @zip, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @zip
        RETURN
      END

    -- Write the ZIP archive and close it.
    EXEC sp_OAMethod @zip, 'WriteZipAndClose', @success OUT
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @zip, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @zip
        RETURN
      END


    PRINT 'ZIP archive created successfully.'

    EXEC @hr = sp_OADestroy @zip


END
GO