Post reply

SSIS, For Variable Lock

  • March 19, 2009 at 2:40 am

    #132158

    I am using one varible in the script task and put it in the varible list in REadwriteVaribale list.

    Now I used the same varible in the another Script task in the Event handler of coming Execute SQL task. I am getting eroor that I cannot read the varable that is already locked and it can be locked once.

    Please help me if anyone knows.

  • March 19, 2009 at 6:01 pm

    #963238

    ammit.it2006 (3/19/2009)

    I am using one varible in the script task and put it in the varible list in REadwriteVaribale list.

    Now I used the same varible in the another Script task in the Event handler of coming Execute SQL task. I am getting eroor that I cannot read the varable that is already locked and it can be locked once.

    Please help me if anyone knows.

    Try not to use ReadWriteVariable, but manually lock-unlock using the VariableDispenser object.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • March 20, 2009 at 12:44 am

    #963338

    hi,

    Lock the variable which we want to write and also use the reset the variabledispenser once your writing has been done.

    Vijay

  • March 24, 2009 at 2:49 am

    #965022

    Thanks For support.

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

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