Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to bulk copy text file form http

Author  Topic 

anup_phansa
Starting Member

6 Posts

Posted - 2009-09-10 : 03:12:35
Hi all

How to bulk copy text file form http,
Please the below sql statement



BULK Insert XYZMaster
from 'http://www.xyz.com/abc.txt'
with
(
FIELDTERMINATOR ='|',
ROWTERMINATOR = '\n'
)



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

   

- Advertisement -