(make sure the file is where you expect it to be) the file is already open by some other app (close the other app to release the file) I have a stored procedure that runs on a job every once in a while to bcp some files left by an application i've written I noticed the files were piling up and bcp wasn't picking them up so i tested in management studio using the following: A good start is to make sure that you have provided the correct file path In this blog post, we will explore the common causes of the “unable to open bcp host data file” error and provide solutions to help you overcome this issue.
If your code is writing the data file, and then reading it with bcp, make sure that you close the data file before trying to read it Failure to do so gives Unable to open host bcp data file This guide covers everything you need to know, from identifying the cause of the error to finding a solution that works for you. Learn how to fix the unable to open bcp host data file error in microsoft sql server with these 4 easy steps, plus faqs and related links Import and export data with ease.
The sql server service and the account that i am using has full access on that drive.
WATCH
