Share via

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
0 comments No comments

Answer accepted by question author

Monalv-MSFT 5,926 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.

Was this answer helpful?

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.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.