Sign in
Microsoft.com
 
Resources for IT Professionals
 
 
 
Resources for IT Professionals > Forums Home > Sandbox Forums Forums > TechNet Sandbox > SSIS Transaction Lock
Ask a questionAsk a question
Search Forums:
 

QuestionSSIS Transaction Lock

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