DtsConvert.GetExtendedInterface method not working in VS 2017

Pranvi Kanwar 86 Reputation points
2021-03-24T17:12:27.4+00:00

I am getting the error while opening the script task in VS 2017 which is as follows: Severity Code Description Project File Line Suppression State Error CS1705 Assembly 'Microsoft.SqlServer.ManagedDTS' with identity 'Microsoft.SqlServer.ManagedDTS, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses 'Microsoft.SqlServer.DTSRuntimeWrap, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' which has a higher version than referenced assembly 'Microsoft.SqlServer.DTSRuntimeWrap' with identity 'Microsoft.SqlServer.DTSRuntimeWrap, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ST_d8c2e88d25064b7f9006e239cabf06b2 Please assist on resolution ![81256-image.png][1] ![81225-error.png][2] [1]: /api/attachments/81256-image.png?platform=QnA [2]: /api/attachments/81225-error.png?platform=QnA

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,891 Reputation points
    2021-03-25T07:58:41.08+00:00

    Hi @Pranvi Kanwar ,

    1.Could you please share the version of the SSDT and SQL Server?

    2.Please delete the Script Task and then recreate new Script Task.

    3.Please check the TargetServerVersion in SSIS project.

    Best regards,
    Mona


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Pranvi Kanwar 86 Reputation points
    2021-03-28T09:10:50.52+00:00

    There was assembly mismatch and the issue got resolved.

    Thank you for assistance.