Post reply

BULK INSERT of remote file

  • March 15, 2010 at 9:59 am

    #230868

    Hi,

    I found many examples of BULK INSERT on the net, like this

    BULK INSERT TempPGNFile

    FROM 'c:\testfile.csv'

    WITH

    (

    ROWTERMINATOR = ''

    );

    What about a remote file? I have just a link on the web. The code below doesn't work for me.

    BULK INSERT TempPGNFile

    FROM 'http://data.domain.com/view_file.aspx?code=234&download=1'

    WITH

    (

    ROWTERMINATOR = ''

    );

    Any tips?

  • March 19, 2010 at 12:18 pm

    #1136956

    hope you have got your answer but if not then just think a simple term....can you simply copy paste the file in your computer without downloading and saving it to system physically

    ----------
    Ashish

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

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