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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-12 : 10:02:40
|
| Jack writes "I have been trying to use the BULK INSERT statement to import data from a text file to a database. The problem is both of the source(text file) and destination(database) are situated on different location or servers. When I am executing my stored procedure I get the system error that says it cannot fined the specified File path." |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-12 : 10:11:02
|
| Do you have the permission to access the path?Peter LarssonHelsingborg, Sweden |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-12 : 11:24:45
|
on a different server? that means a mapped path which means network connection uncertanty... good luck.I once had a weird bug with just that kind of scenario. i read from a mapped drive and although i could reach it withexplorer i could only reach it randomly with bulk insert...Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
BULK INSERT