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

Article translations Article translations
Article ID: 932555 - View products that this article applies to.
BUG #: 50000492 (SQL Hotfix)
Important This article applies to SQL Server 2005 Service Pack 1 build 2047. For later builds of SQL Server 2005 Service Pack 1, see 931593.
Expand all | Collapse all

SYMPTOMS

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
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.
Error message 2
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 message 3
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.

CAUSE

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.

RESOLUTION

Important This article applies to SQL Server 2005 Service Pack 1 build 2047. For later builds of SQL Server 2005 Service Pack 1, see 931593.

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

Collapse this imageExpand this image
Download
Download the hotfix package now.

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:
119591 How to obtain Microsoft support files from online services
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.

Prerequisites

You must have SQL Server 2005 Service Pack 1 (SP1) installed to apply this hotfix. For more information about how to obtain SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
913089 How to obtain the latest service pack for SQL Server 2005

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
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Sqlaccess.dll2005.90.2050.0350,57603-Mar-200715:58x86
Sqlservr.exe2005.90.2050.028,935,59214-Feb-200715:33x86
SQL Server 2005 Analysis Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.2050.014,625,64814-Feb-200715:33x86
SQL Server 2005 Reporting Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.2050.0607,60014-Feb-200715:32x86
Reportingservicesservice.exe9.0.2050.017,26403-Mar-200715:57x86
SQL Server 2005 Notification Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.2050.021,87214-Feb-200715:31x86
SQL Server 2005 Integration Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.scripttask.dll9.0.2050.0157,04003-Mar-200715:58x86
Microsoft.sqlserver.txscript.dll9.0.2050.0210,28803-Mar-200715:58x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvr.exe9.0.2050.0206,19203-Mar-200715:58x86
Msdtssrvrutil.dll2005.90.2050.036,20803-Mar-200715:58x86
Vsa7director.dll8.0.50727.79137,88813-Jan-200700:42x86
Vsapkg.dll8.0.50727.79171,68013-Jan-200700:42x86
Vsapkgp.dll8.0.50727.79113,82413-Jan-200700:42x86
Vsavb7dt.dll8.0.50727.7911,315,84013-Jan-200700:43x86
Vsavbproj.dll8.0.50727.7911,032,19213-Jan-200700:43x86
SQL Server 2005 Tools, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Addlogintoserverrole.sqlNot Applicable28213-Jun-200512:30Not Applicable
Addnon-sqlserveraslinkedserver.sqlNot Applicable79213-Jun-200512:30Not Applicable
Addusertodatabaserole.sqlNot Applicable25613-Jun-200512:30Not Applicable
Createinsteadoftriggerbasictemplate.sqlNot Applicable51113-Jun-200512:30Not Applicable
Createprocedurewithcursoroutputparameter.sqlNot Applicable1,43013-Jun-200512:30Not Applicable
Createprocedurewithoutputparameter.sqlNot Applicable1,11013-Jun-200512:30Not Applicable
Createtriggercontainedifcolumns_updated.sqlNot Applicable66813-Jun-200512:30Not Applicable
Droploginfromserverrole.sqlNot Applicable28613-Jun-200512:30Not Applicable
Dropuserfromdatabaserole.sqlNot Applicable26013-Jun-200512:30Not Applicable
Grantsqlserveraccess.sqlNot Applicable23613-Jun-200512:30Not Applicable
Microsoft.reportingservices.diagnostics.dll9.0.2050.0607,60014-Feb-200715:32x86
Microsoft.sqlserver.scripttask.dll9.0.2050.0157,04003-Mar-200715:58x86
Microsoft.sqlserver.txscript.dll9.0.2050.0210,28803-Mar-200715:58x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvrutil.dll2005.90.2050.036,20803-Mar-200715:58x86
Revokesqlserveraccess.sqlNot Applicable23813-Jun-200512:30Not Applicable
Sqlwb.exe2005.90.2050.0822,64014-Feb-200715:33x86
Vsa7director.dll8.0.50727.79137,88813-Jan-200700:42x86
Vsapkg.dll8.0.50727.79171,68013-Jan-200700:42x86
Vsapkgp.dll8.0.50727.79113,82413-Jan-200700:42x86
Vsavb7dt.dll8.0.50727.7911,315,84013-Jan-200700:43x86
Vsavbproj.dll8.0.50727.7911,032,19213-Jan-200700:43x86
SQL Server 2005 Database Engine, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Sqlaccess.dll2005.90.2050.0357,74403-Mar-200715:58x86
Sqlservr.exe2005.90.2050.039,335,28015-Feb-200713:40x64
SQL Server 2005 Analysis Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.2050.029,526,38415-Feb-200713:40x64
SQL Server 2005 Reporting Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.2050.0607,60015-Feb-200713:40x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.042,35215-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54415-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54415-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.046,44815-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54415-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54415-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.042,35215-Feb-200713:39x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.046,44815-Feb-200713:39x86
Reportingservicesservice.exe9.0.2050.017,26403-Mar-200715:58x86
Reportingservicesservice.resources.dll9.0.2050.013,68015-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.013,68015-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.014,19215-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.013,68015-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.013,68015-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.013,68015-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.013,68015-Feb-200713:39x86
Reportingservicesservice.resources.dll9.0.2050.014,19215-Feb-200713:39x86
SQL Server 2005 Notification Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.2050.021,87215-Feb-200713:39x86
SQL Server 2005 Integration Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.scripttask.dll9.0.2050.0157,04003-Mar-200715:58x86
Microsoft.sqlserver.txscript.dll9.0.2050.0210,28803-Mar-200715:58x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvr.exe9.0.2050.0202,09603-Mar-200715:58x64
Msdtssrvrutil.dll2005.90.2050.040,30403-Mar-200715:58x64
Vsa7director.dll8.0.50727.79137,88813-Jan-200700:42x86
Vsapkg.dll8.0.50727.79171,68013-Jan-200700:42x86
Vsapkgp.dll8.0.50727.79113,82413-Jan-200700:42x86
Vsavb7dt.dll8.0.50727.7911,315,84013-Jan-200700:43x86
Vsavbproj.dll8.0.50727.7911,032,19213-Jan-200700:43x86
SQL Server 2005 Tools, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Addlogintoserverrole.sqlNot Applicable28213-Jun-200512:30Not Applicable
Addnon-sqlserveraslinkedserver.sqlNot Applicable79213-Jun-200512:30Not Applicable
Addsqlserveraslinkedserver.sqlNot Applicable36713-Jun-200512:30Not Applicable
Addsqlserverlogin.sqlNot Applicable46713-Jun-200512:30Not Applicable
Addusertodatabaserole.sqlNot Applicable25613-Jun-200512:30Not Applicable
Attachdatabasetemplate.sqlNot Applicable45413-Jun-200512:30Not Applicable
Attachsinglefiledatabase.sqlNot Applicable49113-Jun-200512:30Not Applicable
Createdatabasemultiplefilegroups.sqlNot Applicable1,92613-Jun-200512:30Not Applicable
Createdatabaseonmultiplefiles.sqlNot Applicable1,39613-Jun-200512:30Not Applicable
Createdatabasespecifyingcollation.sqlNot Applicable66813-Jun-200512:30Not Applicable
Createinsteadoftriggerbasictemplate.sqlNot Applicable51113-Jun-200512:30Not Applicable
Createprocedurewithcursoroutputparameter.sqlNot Applicable1,43013-Jun-200512:30Not Applicable
Createprocedurewithoutputparameter.sqlNot Applicable1,11013-Jun-200512:30Not Applicable
Createrequestresponsewithactivation.sqlNot Applicable2,77913-Jun-200512:30Not Applicable
Createtriggercontainedifcolumns_updated.sqlNot Applicable66813-Jun-200512:30Not Applicable
Createtriggercontainedifupdate.sqlNot Applicable64813-Jun-200512:30Not Applicable
Denysqlserveraccess.sqlNot Applicable23413-Jun-200512:30Not Applicable
Detachdatabasetemplate.sqlNot Applicable27913-Jun-200512:30Not Applicable
Droploginfromserverrole.sqlNot Applicable28613-Jun-200512:30Not Applicable
Dropsqlserverlogin.sqlNot Applicable20113-Jun-200512:30Not Applicable
Dropuserfromdatabaserole.sqlNot Applicable26013-Jun-200512:30Not Applicable
Grantdatabaseaccess.sqlNot Applicable30713-Jun-200512:30Not Applicable
Grantsqlserveraccess.sqlNot Applicable23613-Jun-200512:30Not Applicable
Microsoft.reportingservices.diagnostics.dll9.0.2050.0607,60014-Feb-200715:32x86
Microsoft.sqlserver.scripttask.dll9.0.2050.0157,04003-Mar-200715:58x86
Microsoft.sqlserver.txscript.dll9.0.2050.0210,28803-Mar-200715:58x86
Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-200506:56x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvrutil.dll2005.90.2050.036,20803-Mar-200715:58x86
Revokedatabaseaccess.sqlNot Applicable27413-Jun-200512:30Not Applicable
Revokesqlserveraccess.sqlNot Applicable23813-Jun-200512:30Not Applicable
Scrollcursorwithvariousfetchoptions.sqlNot Applicable1,12213-Jun-200512:30Not Applicable
Sqlwb.exe2005.90.2050.0822,64014-Feb-200715:33x86
Updateextendedproperty.sqlNot Applicable44713-Jun-200512:30Not Applicable
Vsa7director.dll8.0.50727.79137,88813-Jan-200700:42x86
Vsapkg.dll8.0.50727.79171,68013-Jan-200700:42x86
Vsapkgp.dll8.0.50727.79113,82413-Jan-200700:42x86
Vsavb7dt.dll8.0.50727.7911,315,84013-Jan-200700:43x86
Vsavbproj.dll8.0.50727.7911,032,19213-Jan-200700:43x86
SQL Server 2005 Database Engine, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Sqlaccess.dll2005.90.2050.0352,11203-Mar-200715:57x86
Sqlservr.exe2005.90.2050.072,231,79214-Feb-200716:02IA-64
SQL Server 2005 Analysis Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.2050.047,643,50414-Feb-200716:02IA-64
SQL Server 2005 Reporting Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.2050.0607,60014-Feb-200716:02x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.042,35214-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54414-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54414-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.046,44814-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54414-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.050,54414-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.042,35214-Feb-200716:01x86
Microsoft.reportingservices.diagnostics.resources.dll9.0.2050.046,44814-Feb-200716:01x86
Reportingservicesservice.exe9.0.2050.017,26403-Mar-200715:57x86
Reportingservicesservice.resources.dll9.0.2050.013,68014-Feb-200716:01x86
Reportingservicesservice.resources.dll9.0.2050.013,68014-Feb-200716:01x86
Reportingservicesservice.resources.dll9.0.2050.014,19214-Feb-200716:01x86
Reportingservicesservice.resources.dll9.0.2050.013,68014-Feb-200716:00x86
Reportingservicesservice.resources.dll9.0.2050.013,68014-Feb-200716:00x86
Reportingservicesservice.resources.dll9.0.2050.013,68014-Feb-200716:01x86
Reportingservicesservice.resources.dll9.0.2050.013,68014-Feb-200716:01x86
Reportingservicesservice.resources.dll9.0.2050.014,19214-Feb-200716:01x86
SQL Server 2005 Notification Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.2050.021,87214-Feb-200716:01x86
SQL Server 2005 Integration Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.scripttask.dll9.0.2050.0157,04003-Mar-200715:57x86
Microsoft.sqlserver.txscript.dll9.0.2050.0210,28803-Mar-200715:57x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvr.exe9.0.2050.0202,09603-Mar-200715:57IA-64
Msdtssrvrutil.dll2005.90.2050.068,46403-Mar-200715:57IA-64
Vsa7director.dll8.0.50727.79137,88813-Jan-200700:42x86
Vsapkg.dll8.0.50727.79171,68013-Jan-200700:42x86
Vsapkgp.dll8.0.50727.79113,82413-Jan-200700:42x86
Vsavb7dt.dll8.0.50727.7911,315,84013-Jan-200700:43x86
Vsavbproj.dll8.0.50727.7911,032,19213-Jan-200700:43x86
SQL Server 2005 Tools, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Addlogintoserverrole.sqlNot Applicable28213-Jun-200512:30Not Applicable
Addnon-sqlserveraslinkedserver.sqlNot Applicable79213-Jun-200512:30Not Applicable
Addsqlserveraslinkedserver.sqlNot Applicable36713-Jun-200512:30Not Applicable
Addsqlserverlogin.sqlNot Applicable46713-Jun-200512:30Not Applicable
Addusertodatabaserole.sqlNot Applicable25613-Jun-200512:30Not Applicable
Attachdatabasetemplate.sqlNot Applicable45413-Jun-200512:30Not Applicable
Attachsinglefiledatabase.sqlNot Applicable49113-Jun-200512:30Not Applicable
Createdatabasemultiplefilegroups.sqlNot Applicable1,92613-Jun-200512:30Not Applicable
Createdatabaseonmultiplefiles.sqlNot Applicable1,39613-Jun-200512:30Not Applicable
Createdatabasespecifyingcollation.sqlNot Applicable66813-Jun-200512:30Not Applicable
Createinsteadoftriggerbasictemplate.sqlNot Applicable51113-Jun-200512:30Not Applicable
Createprocedurebasictemplate.sqlNot Applicable86813-Jun-200512:30Not Applicable
Createprocedurewithcursoroutputparameter.sqlNot Applicable1,43013-Jun-200512:30Not Applicable
Createprocedurewithoutputparameter.sqlNot Applicable1,11013-Jun-200512:30Not Applicable
Createrequestresponsewithactivation.sqlNot Applicable2,77913-Jun-200512:30Not Applicable
Createtablespecifyingconstraints.sqlNot Applicable64413-Jun-200512:30Not Applicable
Createtablewithrowguidcolcolumn.sqlNot Applicable57013-Jun-200512:30Not Applicable
Createtriggercontainedifcolumns_updated.sqlNot Applicable66813-Jun-200512:30Not Applicable
Createtriggercontainedifupdate.sqlNot Applicable64813-Jun-200512:30Not Applicable
Denysqlserveraccess.sqlNot Applicable23413-Jun-200512:30Not Applicable
Detachdatabasetemplate.sqlNot Applicable27913-Jun-200512:30Not Applicable
Droploginfromserverrole.sqlNot Applicable28613-Jun-200512:30Not Applicable
Dropsqlserverlogin.sqlNot Applicable20113-Jun-200512:30Not Applicable
Dropuserfromdatabaserole.sqlNot Applicable26013-Jun-200512:30Not Applicable
Grantdatabaseaccess.sqlNot Applicable30713-Jun-200512:30Not Applicable
Grantsqlserveraccess.sqlNot Applicable23613-Jun-200512:30Not Applicable
Microsoft.reportingservices.diagnostics.dll9.0.2050.0607,60014-Feb-200715:32x86
Microsoft.sqlserver.scripttask.dll9.0.2050.0157,04003-Mar-200715:58x86
Microsoft.sqlserver.txscript.dll9.0.2050.0210,28803-Mar-200715:58x86
Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-200506:56x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvrutil.dll2005.90.2050.036,20803-Mar-200715:58x86
Revokedatabaseaccess.sqlNot Applicable27413-Jun-200512:30Not Applicable
Revokesqlserveraccess.sqlNot Applicable23813-Jun-200512:30Not Applicable
Scrollcursorwithvariousfetchoptions.sqlNot Applicable1,12213-Jun-200512:30Not Applicable
Sqlwb.exe2005.90.2050.0822,64014-Feb-200715:33x86
Updateextendedproperty.sqlNot Applicable44713-Jun-200512:30Not Applicable
Vsa7director.dll8.0.50727.79137,88813-Jan-200700:42x86
Vsapkg.dll8.0.50727.79171,68013-Jan-200700:42x86
Vsapkgp.dll8.0.50727.79113,82413-Jan-200700:42x86
Vsavb7dt.dll8.0.50727.7911,315,84013-Jan-200700:43x86
Vsavbproj.dll8.0.50727.7911,032,19213-Jan-200700:43x86

STATUS

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

MORE INFORMATION

For more information about this problem, click the following article number to view the article in the Microsoft Knowledge Base:
931846 You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components

Properties

Article ID: 932555 - Last Review: October 8, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Developer Edition
Keywords: 
kbsql2005ssis kbexpertiseadvanced atdownload kbqfe KB932555

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com