er.mayankshukla (5/3/2016)
Hi All,I am using a data load via SSIS, and was expecting row locks on the destination table.
However when I see sys.dm_tran_locks I see resource_type as File locked in X mode, however the resource_description and resource_associated_entity_id are all 0.
[Attached is the screenshot.]
My question is why this File lock appeared here ?
I think table locking is the default behavior of SSIS.
If you want row locks you have to change destination property.
I know OLE DB has row locking.
File lock can appear if your DB has 1 table in the .mdf file.