Post reply

Basic SSIS Transfer Lock Table Problem

  • April 14, 2011 at 2:55 am

    #248866

    Hi,

    I am transferring Datas from One server to another server using SSIS Package. My package running on source server. I didn't select table lock. But destination server's table is locked.

    Has anyone experienced about this?

  • April 14, 2011 at 11:20 pm

    #1311931

    hi

    Change your query and specify the query hints like with (nolock ) on the destnation table..

    Hope this helps

    Thanks

    AnilInampudi

  • April 15, 2011 at 2:24 am

    #1311979

    What destination component did you use exactly?

    Is it a problem that the table is locked?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 16, 2011 at 5:04 am

    #1312430

    What are the tasks used in the package? How is the insert done? Check the OLEDB destination Table Lock option.

  • April 18, 2011 at 12:29 pm

    #1313009

    DeepakKumarKal (4/16/2011)

    What are the tasks used in the package? How is the insert done? Check the OLEDB destination Table Lock option.

    There is a known bug when table is used because SSIS will enable the options Table Lock and Check Constraint which will make the package to fail, disable and rerun.

    Kind regards,
    Gift Peddie

Viewing 5 posts - 1 through 4 (of 4 total)

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