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

Article translations Article translations
Article ID: 932557 - View products that this article applies to.
BUG #: 50000493 (SQL Hotfix)
Important This article applies to the original release version of SQL Server 2005 build 1399. For later builds of SQL Server 2005, see 932556.
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 the original release version of SQL Server 2005 build 1399. For later builds of SQL Server 2005, see 932556.

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.

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.1406.0352,11203-Mar-200723:12x86
Sqlservr.exe2005.90.1406.028,771,24003-Mar-200723:12x86
SQL Server 2005 Analysis Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.1406.014,560,62403-Mar-200723:12x86
SQL Server 2005 Reporting Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.1406.0607,60003-Mar-200723:12x86
Reportingservicesservice.exe9.0.1406.017,26403-Mar-200723:09x86
Rsclientprint.cabNot Applicable1,120,81204-Mar-200710:12Not Applicable
SQL Server 2005 Notification Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.smo.dll9.0.1561.01,561,96818-Feb-200714:39x86
Microsoft.sqlserver.sqlenum.dll9.0.1561.0898,41618-Feb-200714:39x86
Nsservice.exe9.0.1561.021,36018-Feb-200714:39x86
SQL Server 2005 Integration Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.scripttask.dll9.0.1406.0157,04003-Mar-200723:11x86
Microsoft.sqlserver.txscript.dll9.0.1406.0210,28803-Mar-200723:12x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvr.exe9.0.1406.0202,09603-Mar-200723:12x86
Msdtssrvrutil.dll2005.90.1406.036,20803-Mar-200723:10x86
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.1406.0607,60003-Mar-200723:12x86
Microsoft.sqlserver.scripttask.dll9.0.1406.0157,04003-Mar-200723:11x86
Microsoft.sqlserver.txscript.dll9.0.1406.0210,28803-Mar-200723:12x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvrutil.dll2005.90.1406.036,20803-Mar-200723:10x86
Revokesqlserveraccess.sqlNot Applicable23813-Jun-200512:30Not Applicable
Sqlwb.exe2005.90.1406.0822,64003-Mar-200723:12x86
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.1406.0359,79204-Mar-200712:41x86
Sqlservr.exe2005.90.1406.039,484,27204-Mar-200712:41x64
SQL Server 2005 Analysis Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.1406.029,326,19204-Mar-200712:41x64
SQL Server 2005 Reporting Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.1406.0607,60004-Mar-200712:41x86
Reportingservicesservice.exe9.0.1406.017,26404-Mar-200712:40x86
Rsclientprint.cabNot Applicable1,120,81204-Mar-200710:12Not Applicable
SQL Server 2005 Notification Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.1406.021,36004-Mar-200712:40x86
SQL Server 2005 Integration Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.scripttask.dll9.0.1406.0157,04004-Mar-200712:41x86
Microsoft.sqlserver.txscript.dll9.0.1406.0210,28804-Mar-200712:41x86
Msdtssrvr.exe9.0.1406.0198,00004-Mar-200712:41x64
Msdtssrvrutil.dll2005.90.1406.040,30404-Mar-200712:40x64
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.1406.0607,60003-Mar-200723:12x86
Microsoft.sqlserver.scripttask.dll9.0.1406.0157,04003-Mar-200723:11x86
Microsoft.sqlserver.txscript.dll9.0.1406.0210,28803-Mar-200723:12x86
Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-200506:56x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvrutil.dll2005.90.1406.036,20803-Mar-200723:10x86
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.1406.0822,64003-Mar-200723:12x86
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.1406.0354,16004-Mar-200712:45x86
Sqlservr.exe2005.90.1406.072,349,04004-Mar-200712:46IA-64
SQL Server 2005 Analysis Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.1406.047,442,28804-Mar-200712:46IA-64
SQL Server 2005 Reporting Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.reportingservices.diagnostics.dll9.0.1406.0607,60004-Mar-200712:45x86
Reportingservicesservice.exe9.0.1406.017,26404-Mar-200712:44x86
Rsclientprint.cabNot Applicable1,120,81204-Mar-200710:12Not Applicable
SQL Server 2005 Notification Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.1406.021,36004-Mar-200712:44x86
SQL Server 2005 Integration Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Microsoft.sqlserver.scripttask.dll9.0.1406.0157,04004-Mar-200712:45x86
Microsoft.sqlserver.txscript.dll9.0.1406.0210,28804-Mar-200712:45x86
Msdtssrvr.exe9.0.1406.0198,00004-Mar-200712:45IA-64
Msdtssrvrutil.dll2005.90.1406.068,46404-Mar-200712:45IA-64
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.1406.0607,60003-Mar-200723:12x86
Microsoft.sqlserver.scripttask.dll9.0.1406.0157,04003-Mar-200723:11x86
Microsoft.sqlserver.txscript.dll9.0.1406.0210,28803-Mar-200723:12x86
Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-200506:56x86
Microsoft.vsadirector.dll8.0.50727.7916,65614-Jan-200722:00x86
Msdtssrvrutil.dll2005.90.1406.036,20803-Mar-200723:10x86
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.1406.0822,64003-Mar-200723:12x86
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 informationabout 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: 932557 - Last Review: November 20, 2007 - Revision: 2.1
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: 
kbbug kbfix kbqfe kbpubtypekc atdownload kbexpertiseadvanced kbsql2005ssis KB932557

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