Post reply

SSIS package with Merge statement locking the DB

  • December 11, 2014 at 1:09 am

    #397762

    We have a SSIS package which loads the data from csv files to DB. It only loads the new entries ie if the row already exists in the tables than it doesn't insert it. For this we load the CSV to temp tables for respective schemas and than those are compared with base tables of respective schemas and inserted new rows. For this we use Merge statement.

    It take few minutes but the problem is many times it locks the entire DB during this process.

    Can anyone kindly help to troubleshoot this problem?

  • December 11, 2014 at 11:20 pm

    #1764276

    I think I myself found the reason. I need to change the transaction isolation of the package to 'read uncommitted'.

    But another question is the SP having Merge statement is in SQL Server, will changing Isolation level of the Package have effect on the SQL script tasks having SP in database engine?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply