Bulk Insert Failure

Issue: You receive this error message: Could not bulk insert because file '\\servername\shared foldername \application foldername\Inbox\filename.fmt' could not be opened. Operating system error code 5 (error not found)

Solution: Follow these steps:

  1. Check the SQL server to see which user is running MSSQLServer service. If the user account is local, change it to domain and give the user read share permissions and Read NTFS to the application folder \\servername\shared foldername\application foldername.

  2. Launch SQL Server Enterprise Manager, and ensure that the user who created the database has been granted the Bulk Insert Admin role.