SSIS Transaction Lock RRS feed

  • Question

  • Hi,

      I am using a Custom Task(Table Difference) which performs the Inserts,Updates & Deletes operations simultaneously.I am getting the data from 2 sources i.e SAP(Source),SQL Server 2005 & loading it in the same sql server destination.While performing the DML operations,my package is causing locks due to simulatneous dml operations.Pls help.
    Wednesday, September 16, 2009 10:00 AM

All replies