Hi, I have found 2 ways to read or modify variables using script task, 1) Through ReadWriteVariables of the script task 2) Through VariableDispenser what are the cases to use these Methods. which one is better, and what are the disadvantages of individual.. THANKS RAVI

VariableDispenser is generally used when creating custom components so if you're not doing that, use method 1?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: MrWharty.wordpress.com

Here are two perspectives on this debate: A deadlock was detected while trying to lock variables in SSIS Use ReadOnlyVariables and ReadWriteVariables properties in Scripts Hope that helps! http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

None of the methods is better than the other. The result of both methods is the same. The 'advanced version' (with the VariableDispenser) gives you a little more control over what is happening and at what stage the variables are locked and released. But that's only handy for some exceptional cases.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

HI,Jamie Thomson I have Read the first article , so I came with one scenario. like if I use "EXECUTE SQL TASK" in control flow task, and it is using one variable and , If an error Occur in that Task Execution then, In Event handler also I am using the same variable then, the same locking problem will come, In this situation How can we reslove the locking confliction.. can you tell me If I am Wrong.. THANKS RAVI

HI,Jamie Thomson I have Read the first article , so I came with one scenario. like if I use "EXECUTE SQL TASK" in control flow task, and it is using one variable and , If an error Occur in that Task Execution then, In Event handler also I am using the same variable then, the same locking problem will come, In this situation How can we reslove the locking confliction.. can you tell me If I am Wrong.. THANKS RAVI You would need to copy the value of the variable into another variable (using a Script Task) and use that.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me