Lunedì scorso è stata rilasciata una fix per SQL Server 2005 RTM e SP1 che corregge un problema nei SSIS derivato da una patch di sicurezza del Framework .NET 2.0:

This fix updates the SQL Server Integration Services 2005 (SSIS) scripting environment to work with a newly-released patch for a security vulnerability in the .Net Framework 2.0. Without this fix, any VB.Net scripts (Script Task or Script Component) in your SSIS packages may not execute, or work at design-time as expected.

Users may experience one or more of the following symptoms or error messages:
• Existing or new scripts within an SSIS package may fail to start or run appropriately, or may shut down unexpectedly.
• Validation error. Script Task : The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
• Validation error. Data Flow Task: Script Component: The script component is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Component Editor by clicking Design Script button to cause binary code to be generated
• Error: The task cannot execute in 64-bit environment because the script is not pre-compiled. Please turn on the option to pre-compile the script in the task editor.

Il problema consiste nello stabilire quale fix installare in base alla build dell'istanza che intendiamo patchare (potete verificarlo facilmente eseguendo la consueta SELECT @@VERSION):

• SQL Server 2005 RTM build 1399  -> KB932557;
• SQL Server 2005 RTM build 1500 e successive -> KB932556;
• SQL Server 2005 SP1 build 2047  -> KB932555;
• SQL Server 2005 SP1 build 2153 e successive -> KB931593;