Error on Opening SQL Server 2019 Import Export Wizard App

  • Hi there, I am getting this error when opening the app. I've never received this error until my SQL updated a week ago. I am running Microsoft SQL Server 2019. Is there a way to fix this?

    TITLE: SQL Server Import and Export Wizard

    ------------------------------

    The SSIS Runtime object could not be created. Verify that DTS.dll is available and registered. The wizard cannot continue and it will terminate.

    ------------------------------

    ADDITIONAL INFORMATION:

    Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer100'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{3D88ED86-9EE4-41B4-90C5-74182CCC7ECB}' failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (mscorlib)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

     

    • This topic was modified 1 year, 9 months ago by  bwm59550.
    Attachments:
    You must be logged in to view attached files.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Can you check for MSI missing and fix the same.  Kindly update post that.

     

    Regards
    Durai Nagarajan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply