Help and Support
 

powered byLive Search

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

View products that this article applies to.
Article ID:919224
Last Review:November 20, 2007
Revision:3.2
BUG #: 434935 (SQLBUDT)
On This Page

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.

Back to the top

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.

Back to the top

RESOLUTION

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

Back to the top

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"

Back to the top

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 (http://support.microsoft.com/kb/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.

Back to the top

STATUS

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

Back to the top

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.

Back to the top

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

Back to the top

Keywords: 
kbsql2005ssis kbsql2005setup kbexpertiseinter kbexpertiseadvanced kbtshoot kbbug KB919224

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.