SSIS Runtime Object could not be created error:

Hot Topic

SQL Code converting a String to a number
Problem installing SQL Server 2005 Express with Advance Services CTP
2005 Reporting services and Java
HOWTO: Script object as execute?
who can help me?
table schema changes not being propagated - merge replication
ExecuteSQL task has changed
MSDTC - The Transaction Manager is not available
Query filtering problem
Set up Login - Missing option for sp_execute

SQL Server

"product level is insufficient" message during flat file import
Get Date Range
problem in creating database and table in one shot
performance between parent-child and regular
How to avoid Caching of Reports?
Reporting Services 2005 xml datasource
Preview a Report in Design Mode (VS 2005)
Connect SQL server Over Internet
How to find out when a user last logged in
Moving a SQL2K publisher to a SQL 2005 instance.

SSIS Runtime Object could not be created error:

I am using SQL Server 2005 Version 9.00.1399.06 (Intel X86).

Whether I try to start a new Integration Services project in Visual Studio or try to import data into a database I receive the following error:

SSIS Runtime Object could not be created. Verify the DTS.dll is available and registered. The wizard can not continue and will terminate.

Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to interface type
'Microsoft .SqlServer.DTS.Runtime.Wrapper.IDTSContainer90'
This operation failed because the QueryInterface call on the COM component for the interface failed due to the following error: Library not registered. (Exception from HRESULT: 0X80028010) (TYPE_E_LIBNOTREGISTERED)).

I have no idea why I am getting this error and would appreciate any help. I'm sure some of you SQL Server Gurus will know right away.

Answer this question

SSIS Runtime Object could not be created error:

  • R Hearn

    Hi,

    It solved my problem, too.

    Thanks,

    Zoli

  • Subrajit

    I'm moving this thread to the SSIS forum in the hopes that someone there will help you.

    Paul

  • khaley

    I had the exact same issue as swtjen01 and I did the regsvr32 on dts.dll and it fixed the problem. This only occurred after I installed SP1.

  • JoelAraujo

    This is a problem with SQL setup, you may need to reinstall the product.

    You may try to just register 'dts.dll' using regsvr32.exe, but this error may indicate a bigger problem with setup.

  • gharryh

    Hi,

    I had the same problem, and re-registering the "dts.dll" worked for me.

    thanks
  • SSIS Runtime Object could not be created error:
Answer this question