question

PranviKanwar-2531 avatar image
0 Votes"
PranviKanwar-2531 asked Monalv-msft edited

DtsConvert.GetExtendedInterface method not working in VS 2017

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]: /answers/storage/attachments/81256-image.png [2]: /answers/storage/attachments/81225-error.png

sql-server-integration-services
image.png (111.9 KiB)
error.png (107.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @PranviKanwar-2531 ,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PranviKanwar-2531 avatar image
0 Votes"
PranviKanwar-2531 answered Monalv-msft commented

There was assembly mismatch and the issue got resolved.

Thank you for assistance.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PranviKanwar-2531 ,

I am glad to hear that your issue got resolved.

Please accept your own answer. This can be beneficial to other community members reading this thread. Thank you.

Best regards,
Mona

0 Votes 0 ·