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.
| Author |
Topic |
|
harsh.dhawan
Starting Member
10 Posts |
 Posted - 2008-07-09 : 07:45:26
|
| Hi AllI need to insert the rows of file into database, but the problem is that the file which i want to process is on one server and my database is on another server. Is there any way by which i can process that file directly through BULK INSERT.Cheers Harsh Dhawan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-09 : 07:51:19
|
| try giving UNC path for file like \\yourserver\drive\... |
 |
|
|
harsh.dhawan
Starting Member
10 Posts |
Posted - 2008-07-09 : 07:55:05
|
| It not working by giving this path.Its giving error, file could not be opened.Operating system error code 1326(Logon failure: unknown user name or bad password.Even it tried by mapping the drive where the file is present, but its not working.Harsh Dhawan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-09 : 07:56:41
|
| Do you have permissions to access the file from server? |
|
|
|
harsh.dhawan
Starting Member
10 Posts |
Posted - 2008-07-09 : 08:00:03
|
| Thanks for your prompt reply...Yes, i can open that file on that server where file is present by logging into the server where the database present.Harsh Dhawan |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-09 : 08:19:27
|
| May be this is problem:-http://www.dbforums.com/showthread.php?t=890963 |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-07-09 : 08:19:29
|
| I'm guessing that the fetching server process probably doesn't have permissions to access that share on the host server.I'm right in thinking that the query gets run with the db's service permissions which are not necessarily the same permissions as the windows user who's logged into the server aren't I?-------------Charlie |
|
|
|
|
|
|
BULK INSERT