We have tree servers, one application server, one database server and one domain controler, we need to use SQL Bulk Insert t put data in SQL server with files located on application server.
I put our SQL to start with one user in our domain and we use windows sharing to get all data and insert in SQL server.
But we have some errors with permissions, when i try to map one directory from application server to database server does not work, but when i try to map one directory from database server to application server works fine.
If i use the same user in both servers, i don't know why doesn't work in both ways.
In my Bulk insert i have this error:
Cannot bulk load because the file"\\XXX.X.XXX.XXX\d\home\XXXX\Web\GP2011\XX\2011\XX\R
2_XXX102011_S5_SP.txt" could not be opened. Operating system error code 1265(error not found).