Welcome to EMC Consulting Blogs Sign in | Join | Help

Steve Wright's Blog (2005 - 2012)

I have now left EMC Consulting, if you wish to continue to receive new content then please subscribe to my new blog here: http://zogamorph.blogspot.com

SSIS Variable Deadlock

I have noticed a problem with the script task within SSIS. The problem occurs when a script task encounters an error and the SSIS on-error event also has a script task that uses a variable that is being locked by the script task that raised the error.  The problem seems to be that the SSIS on-error event fires and runs before the script task that raised the error has finished and released its lock on the variable.  I have even tred to overcome this problem by using a try/catch block to release the variable locks but this also failed to resolve the problem.

Published 09 February 2006 14:50 by steve.wright
Anonymous comments are disabled

This Blog

News

Locations of visitors to this page
Powered by Community Server (Personal Edition), by Telligent Systems