Error SQL Server Data Tools for Visual Studio - DQS - System.NotImplementedException

Question

When I create a Connection to DQS in an SSIS Project I get System.NotImplementedException error after the build. I am using Visual Studio 2017

Running SQL Server Data Tools for Visual Studio 2017

This is the error I get:

Severity Code Description Project File Line Suppression State Error System.NotImplementedException: The method or operation is not implemented. at Microsoft.SqlServer.Dts.Runtime.Interop.ProjectInterop.ReferencePackage(Package package, String packageLocation) at Microsoft.SqlServer.Dts.Runtime.PackageItem.Load(IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.PackageItem.get_Package() at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.IncrementalBuildThroughObj(IOutputWindow outputWindow) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.BuildIncremental(IOutputWindow outputWindow) 0

Hi, thanks for the response. I just realized that I am missing all the DTS packages. When can I download and install them. Thanks for the help — Mgcobo Gwampi, May 23 '19 at 11:33
@MgcoboGwampi, I got the same error also. Can you add a link to where you download a DTS package?I'm very new to SSIS so please forgive me for my ignorance. Also, I'm running VS 2017 against SQL 2012. — Danny, May 23 '19 at 14:37
https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017. — Mgcobo Gwampi, May 24 '19 at 08:02
Not yet, I think i'm going to give up for now. I wish you the best of luck @MgcoboGwampi. — Danny, May 28 '19 at 15:00

score 0 · Answer 1 · edited Jul 17 '19 at 09:10

0

This is a known issue by Microsoft. It can be resolved by using an older version of SSDT. Works fine with SSDT FOR vs2017 15.9.0.

https://learn.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-2017

edited Jul 17 '19 at 09:10

Amira Bedhiafi

8,088
6
24
60

answered Jul 17 '19 at 07:46

mytkavish

97
1
6

Error SQL Server Data Tools for Visual Studio - DQS - System.NotImplementedException

1 Answers1