How to bulk copy text file form http,

• anup_phansa

  SSC Enthusiast

  Points: 102

  More actions

  September 10, 2009 at 5:34 am

  #71757

  Hi all

  How to bulk copy text file form http,

  please see the below SQL statement

  BULK Insert XYZMaster

  from 'http://www.xyz.com/abc.txt'

  with

  (

  FIELDTERMINATOR ='|',

  ROWTERMINATOR = ''

  )

  Error : Could not find server 'IDXServer' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

  Regards

  anup

• vallolet04

  Mr or Mrs. 500

  Points: 554

  More actions

  September 10, 2009 at 1:02 pm

  #1051903

  check what's on the abc.txt file is probably using the server that is asking you to link

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 11, 2009 at 1:11 am

  #1052099

  You cannot BULK INSERT from HTTP. You will have to download the file first.

  The file can be downloaded with some tool like cURL (http://curl.haxx.se/).

  Hope this helps

  Gianluca

  -- Gianluca Sartori