Post reply

SSIS : ETL tables locks

  • August 8, 2007 at 5:07 am

    #118078

     

    Hi pals,

    I have one doubt. During my ETL process, my execution has been terminated abnormally.In that case does my tables participating in ETL will get locked.

    If my ETL is abnormally terminated, i dont want my tables to get locked.

    How to resolve such an issue.How to know my tables are locked.

    Regards,

    franky

  • August 8, 2007 at 6:32 am

    #725408

    Hi,

     

    Not quite sure what you are asking but here goes...

     

    If you are bulk loading and something goes wrong, the table will be locked for the very (normally) duration while SQL rolls back the rows inserted.

    If you have a large commit value (Number or rows it inserts before commiting), this could take longer.

     

    There is nothing you can do about this locking while it is rolling back but once done, the table will be released.

    You can reduce the commit size to minimise the effect but that will slow your insert.

    running sp_lock

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 8, 2007 at 7:37 am

    #725432

    Thanks Crispin.

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

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