KBI 311718 Many .BAD Files In SQL Bulk Insert Folder


Argent Advanced Technology – All versions


Monday, 8 October 2018


Many .BAD files were found in the SQL Bulk Insert Folder

Technical Background

After further examining the logs, it was discovered that the Argent Service Account did not have the right permissions

The following lines were found in the Argent Service Log:

05 Oct 2018 00:05:11.355 ARGENTSERVER DOMAIN\Argent ***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp

(D6190_Execute_SQL_With_Error) at line 4413: ODBC Exception.

Microsoft Error Code = You do not have permission to use the bulk load statement


The Argent Service Account must have dbowner privileges or the ‘bulkadmin’ database role to be able to execute bulk insert statements

In SQL Management Studio -> Object Explorer, navigate to ‘Security’ -> ‘Logins’ -> Select the Argent Service Account and right click and select ‘Properties’

Under ‘Server Roles’ ensure that the bulkadmin role is checked