Post reply

Import a zip file from a HTTP page

  • January 21, 2009 at 9:32 am

    #130312

    I am trying to build a SSIS package that will check out a http url for a zip file, this file should be then downloaded and then transferred to a table.

    I have done similar processes using FTP and the FTP task, but i am struggling a bit on how i would use a HTTP page download as a data source, I am assuming that it may require some custom scripts.

    Does anyone have any advice on how to download a file from a http site via SSIS ?

  • January 21, 2009 at 4:10 pm

    #930777

    You could use a Script Task to do this. The classes in the System.Net namespace is what you will need. WebClient or even HttpWebRequest and HttpWebResponse classes. Just Google around for lots of sample code.

  • January 23, 2009 at 12:05 am

    #931653

    steveb (1/21/2009)

    I am trying to build a SSIS package that will check out a http url for a zip file, this file should be then downloaded and then transferred to a table.

    I have done similar processes using FTP and the FTP task, but i am struggling a bit on how i would use a HTTP page download as a data source, I am assuming that it may require some custom scripts.

    Does anyone have any advice on how to download a file from a http site via SSIS ?

    Check this script for ideas.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 3 posts - 1 through 2 (of 2 total)

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