unable to open bcp host data-file

So when I am using bcp utility in sql server I got this error. All syntax are fine. I was wandering. Issue was sql agent’s user not having permission to access host file location. So first I wanted to know sql agent’s current user. I used following query to sql server service acounts. Then grant permission to sql agent user. Everything works fine. Advertisements