Deadlocking in SSIS – yes you can get deadlocks with variables

Darren has written a great post about how locking occurs for SSIS variables. http://www.sqlis.com/sqlis/post/A-deadlock-was-detected-while-trying-to-lock-variables-in-SSIS.aspx

Its really important to understand this stuff as it is cruicial especially if you need to run script components in parallel, or access variables in parts of the script component that SSIS doesn’t normally allow.

The locking happens in most parallel systems, especially in SQL. Understanding how it affects you is very important.

Published Wednesday, August 11, 2010 11:41 AM by simonsabin

Comments

# Twitter Trackbacks for Deadlocking in SSIS ??? yes you can get deadlocks with variables - Simons SQL Blog [sqlblogcasts.com] on Topsy.com

Pingback from  Twitter Trackbacks for                 Deadlocking in SSIS ??? yes you can get deadlocks with variables - Simons SQL Blog         [sqlblogcasts.com]        on Topsy.com

Wednesday, August 11, 2010 12:24 PM by SimonS Blog on SQL Server Stuff

# Deadlocking in SSIS – yes you can get deadlocks with variables

Darren has written a great post about how locking occurs for SSIS variables. http://www.sqlis.com/sqlis