FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds

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.

When this problem occurs, you may receive one or more of the following error messages:

Error message 1

Error message 2

Error message 3

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.

Important This article applies to the original release version of SQL Server 2005 build 1500 and later. For earlier builds of SQL Server 2005, see 932557  (http://support.microsoft.com/kb/932557/[EN]/ ) .

The following file is available for download from the Microsoft Download Center:

Download the hotfix package now. (http://www.microsoft.com/downloads/details.aspx?familyid=8AF6C597-0F18-4E61-B3D2-AAD66CDCACF5)

Release Date: April 2, 2007

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Restart information

You may have to restart the computer after you apply this hotfix.

File information

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain all the files that you must have to fully update a product to the latest build.

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

SQL Server 2005 Database Engine, 32-bit version

SQL Server 2005 Analysis Services, 32-bit version

SQL Server 2005 Reporting Services, 32-bit version

SQL Server 2005 Notification Services, 32-bit version

SQL Server 2005 Integration Services, 32-bit version

SQL Server 2005 Tools, 32-bit version

SQL Server 2005 Database Engine, x64-based version

SQL Server 2005 Analysis Services, x64-based version

SQL Server 2005 Reporting Services, x64-based version

SQL Server 2005 Notification Services, x64-based version

SQL Server 2005 Integration Services, x64-based version

SQL Server 2005 Tools, x64-based version

SQL Server 2005 Database Engine, Itanium architecture version

SQL Server 2005 Analysis Services, Itanium architecture version

SQL Server 2005 Reporting Services, Itanium architecture version

SQL Server 2005 Notification Services, Itanium architecture version

SQL Server 2005 Integration Services, Itanium architecture version

SQL Server 2005 Tools, Itanium architecture version

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

For more information about this problem, click the following article number to view the article in the Microsoft Knowledge Base: