problems with bulk insert of text files

[Andre]

Hello,

I try to insert data to table with bulk insert, but it does not work.
The user rights on the SQL Server are correct, I think, and there is no firewall or other restriction to reach the data-file over TCP/IP.
Each time I try, I get a errormessage that the data-file con not be opened.
(System-Error-Code 3 or 53 or 1326)

Thank´s for help
Andre

[MAK]

does the bulkadmin have read access to the file on the network?

[Andre]

at the moment, I use only database users with SQL Server Security, but I created a new one using windows security, the result is the same.

[MAK]

System errors
3- ERROR_PATH_NOT_FOUND
53- ERROR_BAD_NETPATH
1326 - ERROR_LOGON_FAILURE

please check whether the path is right and the login has permission to it.

[Andre]

the network path was right but it was not possible to solve the
"permission" problem accessing the file over network, so i asked my win-adm to create a share on the server where the SQL Server runs. Now it works...