Post reply

Import Data from Web Address To SQL Server table

  • August 17, 2011 at 1:15 pm

    #243347

    Hi

    My first post so hope I am posting in the correct forum.

    I am trying to get data from a csv file on a remote web server into a SQL Server table. I know how to get a csv into a SQL Server table when the file is on the local machine or a machine on the network by using SSIS and BULK INSERT but I don't know how to do it using a remote web address URL e.g. http://www.<server_name&gt;.com/file.csv

    There is no login to this server as the file is available to all who want to DL it.

    Is this possible to do in SSIS or preferably with BULK INSERT or will I have to DL the file to a local machine first?

    Many thanks in advance for any assistance.

  • August 17, 2011 at 1:30 pm

    #1369815

    I am sure there is a way to do it but, what I would do is use SSIS to bring the file locally and then bulk import it.

  • August 17, 2011 at 2:14 pm

    #1369844

    Theres an ftp task in SSIS, but if you cannot log onto the website to download the file then another way would be to create a SQL job. You could use a command line program called cURL to download the csv file and then use BULK INSERT to import to the table.

    Adam Durr
    Remote DBA support
    www.bluegecko.net

  • August 17, 2011 at 3:02 pm

    #1369871

    Works a treat. Thanks.

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

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