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 2008 Forums
 Transact-SQL (2008)
 BCP error 15105

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?
Go to Top of Page
   

- Advertisement -