Kettle script error

Products

• CA Identity Manager

Issue/Introduction

Getting following error while execute Kettle script

DB Error: You do not have permission to use the bulk load statement. (80040E14)
Query: SET DATEFORMAT dmy BULK INSERT DataTypes FROM '\\hostname\ig_bulk_insert\BulkTempDirectory\EurekifySage_BulkInsert_sa-install-caigp_20240507_051746_DataTypesTmp.tbl'  WITH ( KEEPIDENTITY, FIELDTERMINATOR = '  ', ROWTERMINATOR = '|', CODEPAGE = '1252')Failed to write table 'DataTypes' data from BULK INSERT file '\\hostname\ig_bulk_insert\BulkTempDirectory\EurekifySage_BulkInsert_sa-install-caigp_20240507_051746_DataTypesTmp.tbl'

Environment

Identity Governance 14.4

Cause

Insufficient permission

Resolution

Adding bulk admin permission by following 

1) Under MSSQL management tool, find the user that would like to use to access the folder

2) On the Server Roles check bulkadmin 

3) On the folder that will be used for bulk insert, right click on the properties --> Security --> Edit 

4) Add the user that was configure on the step 1