Deadloack Issue with SSIS Variable


Darren Green has a good post about this issue in SSIS and he provides a simple solution for it.

http://www.sqlis.com/sqlis/post/A-deadlock-was-detected-while-trying-to-lock-variables-in-SSIS.aspx


    Variables lockedVariables = null;
                    Dts.VariableDispenser.LockOneForWrite("ConcatenatedError", ref lockedVariables);
                    lockedVariables["ConcatenatedError"].Value = "MN GM FTP File Error!";
                    lockedVariables.Unlock();

                    Dts.Events.FireError(0, "FTP", "FTP Error", String.Empty, 0);



 
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s