HTTPS Download File of any Type

Download a file via HTTPS to disk. The file is downloaded in streaming mode directly to the filesystem. Any size file can be downloaded. The memory footprint is constant and small.

Download Chilkat HTTP ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    --  Any string unlocks the component for the 1st 30-days.
    EXEC sp_OAMethod @http, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        RETURN
      END

    --  If the URL requires authentication to access, then set
    --  a login and password.
    --  Note: Authentication has nothing to do with the fact that SSL is used.
    --  Both SSL and non-SSL URLs may require authentication.
    --  Login/password authentication is only required if the webmaster
    --  explicitly protects the resource from public access.
    EXEC sp_OASetProperty @http, 'Login', 'myLogin'
    EXEC sp_OASetProperty @http, 'Password', 'myPassword'

    --  ----------------------------------------------------
    --  You'll obviously need to change the URL before running this...
    --  ----------------------------------------------------
    --  Download a file from a web server over SSL (HTTPS)
    --  You only need to provide the "https" in the URL to use SSL:
    EXEC sp_OAMethod @http, 'Download', @success OUT, 'https://www.my-website.com/something.zip', 'something.zip'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN
        PRINT 'Download Complete!'
      END
END
GO