Ask a questionAsk a question
 

QuestionSSIS Transaction Lock

  • Wednesday, September 16, 2009 10:00 AMIshu Goyal Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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.