When you run a Microsoft SQL Server Integration Services (SSIS) package that contains a Visual Studio for Applications (VSA) script task or a script component in Microsoft SQL Server 2005, the script task or the script component may not run correctly or may not work as expected at design time. Additionally, new or existing scripts in an SSIS package may not start correctly or run correctly. Additionally, the scripts may shut down unexpectedly.
This problem occurs because of a recent change in the common language runtime (CLR) workstation runtime for builds of the Microsoft .NET Framework 2.0. The CLR workstation runtime is named Mscorwks.dll. The change introduces a compatibility problem for the Microsoft Visual Basic runtime engine that VSA uses. The Visual Basic runtime engine is named Vsavb7rt.dll. The problem prevents assemblies from being created correctly during the macro compilation operation. Because of this problem, existing packages that contain compiled scripts do not run.
This fix updates the SQL Server Integration Services 2005 (SSIS) scripting environment to work with the updated CLR workstation runtime.
Microsoft, SQL Server 2005, Service Pack, Update, Download