Bulk Insert row lock not supported

[aburht]

Bulk insert operations are not supporting row level locks, I don't see options in IbulkOptions, As a results transactions are experiencing delays and potential deadlocks

Expected behaviour:

Bulk insert operations should support row level locks

Software versions

• NodeJS:
• node-mssql:
• SQL Server:

[dhensby]

I believe this is a feature request to add a lock configuration during bulk insert operations, is that correct?

Locking seems to be managed via dedicated options (https://learn.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver16#tablock), I'm not clear on how you would specify a row level lock.

Do you have a suggestion for how to implement this feature?