connection for other server

[jawan]

I have one file on other server, i need to read that file, put the information in table, every thing is fine but how to give path (Conection) for other server's hard drive in query...?

 

[nigelrivett]

Share the path and use

'\\servername\sharedpath\filename'

Better to copy the file to the local server before doing the import (bcp?)
see

http://www.nigelrivett.net/ImportTextFiles.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[jawan]

I have following error

Server: Msg 4861, Level 16, State 1, Line 11
Could not bulk insert because file '\\BDoven\c:\Items.txt' could not be opened. Operating system error code 53(The network path was not found.).

while i have all connections.

 

[nigelrivett]

The share won't be c: - you will have given it a name when you shared it or c$ for the admin share (not advisable). The sql server service will probably need permission on this share.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.