ssis

Why do I get the error: "cannot communicate with the debug host process" when attempting to execute an SSIS package?


I create a new package in SSIS and when I try to run the package, SSIS returns the following error (displayed in a Visual Studio Error Dialog):

Cannot communicate with the debug host process. The IDtsHost interface is not registered.
(Microsoft.DataTransformationServices.VsIntegration"

Environment: VS 2019 with newest SSIS Extension Installed. The package appears to be created correctly and the build succeeds.

The error happens even if the package is trivial "hello world" type of package.

How can I resolve this?


Solution

  • The problem in this case was the selected targeted version of SQL Server. My project was configured to target "SQL Server 2017", but was connected to a server running SQL Server 2012.

    If you're seeing this error, this may be the reason. Here are the steps to change this:

    1. Go to the properties page of the Integration Services project that contains the affected package (right-click on the project in Solution Explorer and select Properties)
    2. In the Property Pages dialog, navigate to Configuration Properties > General.
    3. Under the property group Deployment Target Version, for the TargetServerVersion property, select the SQL Server version that matches the one you're connecting to.