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 |
|
venablc
Starting Member
2 Posts |
Posted - 2010-01-11 : 05:13:19
|
| Hi,I am running SQL 2008 on windows server 2008, I am trying to BCP in a file from a mapped network drive however am getting the following error message:Cannot bulk load because the file "Y:\cleaned_633988003382000225.hlr" could not be opened. Operating system error code 3(failed to retrieve text for this error. Reason: 15105).The overall scenario is that I have a file on another box on the same network which needs to be BCP'd into our database. The other box which the file resides on is an FTP server, originally we would FTP up to a virtual FTP drive which was mapped over to the database leaving the file on the local drive of the database and BCPing was no problem. Since upgrading to windows server 2008 this has not work hence looking for alternatives such as mapping back the other way from our database server to our FTP server.Any suggestions on how we might fix the above error or other methods we could try to get the file from our web server BCPd into our database would be much appreciated!Regards,Chris V |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-11 : 09:36:42
|
| are you using UNC path if file is in another computer? |
 |
|
|
|
|
|