SQL Server

Create an MHT Archive from a URL into a ZIP

Demonstrates Mht.GetAndZipMHT, which creates MHT output from a live web page and stores it as an entry inside a ZIP archive.

The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background. An MHT (MHTML) web archive is a single MIME file that bundles an HTML page together with its referenced resources, such as images and style sheets, so the page can be stored or viewed offline as one file. The ZIP is created if it does not already exist; otherwise the entry is added to it.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

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

    --  The file paths are relative to the application's current working directory.  Absolute paths
    --  may also be used.  Supply the paths appropriate to your own environment.

    --  Create MHT output from a live web page and store it as an entry inside a ZIP archive.  The 2nd
    --  argument is the entry name within the ZIP; the 3rd is the ZIP file path.  The ZIP is created if it
    --  does not already exist.
    EXEC sp_OAMethod @mht, 'GetAndZipMHT', @success OUT, 'https://example-code.com/crumb/index.html', 'page.mht', 'qa_output/page.zip'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mht, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mht
        RETURN
      END

    PRINT 'MHT stored in the ZIP archive.'

    EXEC @hr = sp_OADestroy @mht


END
GO