Lorenzo Benaglia


Storie di un SQLlaro mannaro...
Archivio Posts
Anno 2010

Anno 2009

Anno 2008

Anno 2007

Anno 2006

Anno 2005
Calendario
dicembre 2024
lmmgvsd
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

SQL SSIS VSA fix (RTM and SP1 ONLY!!)

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;

Categoria: SQL Server
giovedì, 05 apr 2007 Ore. 11.50
Statistiche
  • Views Home Page: 969.042
  • Views Posts: 716.460
  • Views Gallerie: 13.862.824
  • n° Posts: 300
  • n° Commenti: 314
Mappa





















Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003