Knowledge Base

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

Article ID: 919224

Article Last Modified on 11/20/2007

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 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Enterprise X64 Edition
Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems

BUG #: 434935 (SQLBUDT)

SYMPTOMS

You install a Microsoft SQL Server 2005 hotfix package on a computer that has a 64-bit processor. When you connect to SQL Server 2005 Integration Services (SSIS) by using SQL Server Management Studio, you receive an error message that resembles the following:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:
Connect to SSIS Service on machine "ComputerName" failed:
Error loading type library/DLL.

Additionally, when you try to create or to edit a maintenance plan, you receive one of the following error messages:

Error message 1

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Program Location:
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.SqlServer.Management.DatabaseMaintenance.TaskContextUI.InitializeConnectionCombo(String connectionName)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskBackupForm.SetTask(DbMaintenanceBackupTask task)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskBackupForm..ctor(TaskHost taskHost, IServiceProvider provider)
at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskBackupUI.GetView() at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.GetTaskEditor()

Error message 2

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

Program Location:
at Microsoft.SqlServer.Dts.Runtime.Sequence.get_Properties()
at Microsoft.DataTransformationServices.Design.DtsBaseDesigner.PreFilterProperties(IDictionary properties)
at Microsoft.DataTransformationServices.Design.DtsPropExpressionsDesigner.PreFilterProperties(IDictionary properties)
at Microsoft.DataTransformationServices.Design.DbMaintSequenceDesigner.PreFilterProperties(IDictionary properties)
at System.ComponentModel.Design.ComponentDesigner.System.ComponentModel.Design.IDesignerFilter.PreFilterProperties(IDictionary properties)
at System.ComponentModel.Design.TypeDescriptorFilterService.System.ComponentModel.Design.ITypeDescriptorFilterService.FilterProperties(IComponent component, IDictionary properties)
at Microsoft.DataTransformationServices.Design.DtsTypeDescriptorFilterService.System.ComponentModel.Design.ITypeDescriptorFilterService.FilterProperties(IComponent component, IDictionary properties)
at System.ComponentModel.TypeDescriptor.PipelineFilter(Int32 pipelineType, ICollection members, Object instance, IDictionary cache)
at System.ComponentModel.TypeDescriptor.GetPropertiesImpl(Object component, Attribute[] attributes, Boolean noCustomTypeDesc, Boolean noAttributes)
at System.ComponentModel.TypeDescriptor.GetProperties(Object component)
at Microsoft.DataWarehouse.Design.Cud.VsTransaction.ChangeProperty(Object obj, String propertyName)
at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

This problem occurs if one of the following conditions is true:

The SQL Server 2005 Integration Services hotfix package is installed. However, the SQL Server 2005 Tools hotfix package is not installed.
You install the SQL Server 2005 Tools hotfix package before you install the SQL Server 2005 Integration Services hotfix package.
You are running two instances of SQL Server 2005 on the computer. Additionally, the versions of both instances of SQL Server are earlier versions than Microsoft SQL Server 2005 Service Pack 2 (SP2).
The computer is running an instance of SQL Server 2005 with SP2. Additionally, you install a post-SP2 hotfix on this instance. Then you install a second instance of SQL Server 2005. On the second instance, you install SQL Server 2005 SP2.

CAUSE

This problem occurs because the installer unregisters the 32-bit Dts.dll file when the installer installs the 64-bit Dts.dll file. The 64-bit Dts.dll file is installed together with SQL Server 2005 SP2. Additionally, the 64-bit Dts.dll file may be installed together with any SSIS hotfix package that contains the 64-bit Dts.dll file.

RESOLUTION

To resolve this problem, use one of the following methods, depending on the version of each instance of SQL Server 2005.

Method 1

If the versions of the instances of SQL Server 2005 are not earlier than SQL Server 2005 SP2, run the following command at a command prompt to register the 32-bit Dts.dll file:

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"

Method 2

If the version of an instance of SQL Server 2005 is earlier than SQL Server 2005 SP2, use one of the following methods:

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2005. For more information, 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
Install the hotfix packages in the following order:
- SQL Server 2005 Database Engine
- SQL Server 2005 Analysis Services
- SQL Server 2005 Integration Services
- SQL Server 2005 Notification Services
- SQL Server 2005 Reporting Services
- SQL Server 2005 Tools
Note You must install all the hotfix packages, even if you do not run a particular component.

STATUS

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

MORE INFORMATION

You can view the Application log in Event Viewer to determine the order in which the hotfix packages were installed. If the order of installation differs from the following order, reinstall the hotfix packages in the following order:

Product: Microsoft SQL Server 2005 - Update 'Hotfix 2153 for SQL Server Database Services 2005 (KB918222)' installed successfully.
Product: Microsoft SQL Server 2005 Analysis Services - Update 'Hotfix 2153 for SQL Server Analysis Services 2005 (KB918222)' installed successfully.
Product: Microsoft SQL Server 2005 Integration Services - Update 'Hotfix 2153 for SQL Server Integration Services 2005 (KB918222)' installed successfully.
Product: Microsoft SQL Server 2005 Notification Services - Update 'Hotfix 2153 for SQL Server Notification Services 2005 (KB918222)' installed successfully.
Product: Microsoft SQL Server 2005 Reporting Services - Update 'Hotfix 2153 for SQL Server Reporting Services 2005 (KB918222)' installed successfully.
Product: Microsoft SQL Server 2005 Tools - Update 'Hotfix 2153 for SQL Server Tools and Workstation Components 2005 (KB918222)' installed successfully.

Note The source of these events is MsiInstaller.

Keywords: kbtshoot kbbug kbexpertiseadvanced kbexpertiseinter kbsql2005setup kbsql2005ssis KB919224

Microsoft KB Archive/919224

Contents