You are currently offline, waiting for your internet to reconnect

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

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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.
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:

DownloadDownload 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
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
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.1406.014,560,62403-Mar-200723:12x86
SQL Server 2005 Reporting Services, 32-bit version
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
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
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
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
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
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.1406.029,326,19204-Mar-200712:41x64
SQL Server 2005 Reporting Services, x64-based version
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
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.1406.021,36004-Mar-200712:40x86
SQL Server 2005 Integration Services, x64-based version
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
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
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
File nameFile versionFile sizeDateTimePlatform
Msmdsrv.exe9.0.1406.047,442,28804-Mar-200712:46IA-64
SQL Server 2005 Reporting Services, Itanium architecture version
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
File nameFile versionFile sizeDateTimePlatform
Nsservice.exe9.0.1406.021,36004-Mar-200712:44x86
SQL Server 2005 Integration Services, Itanium architecture version
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
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: 11/20/2007 17:46:00 - Revision: 2.1

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

  • kbbug kbfix kbqfe kbpubtypekc atdownload kbexpertiseadvanced kbsql2005ssis KB932557
Feedback
ld(m);