I'm using Integration to load into an identical table in another database on the same instance, but the Integration package does not end the operation when I try to perform an insert with a high number of records (34,000) when the amount of records are smaller the package runs successfully.
Can anyone tell me if there is an insert lock on the sql server?