I installed SQL Server 2016 Dev with all items and options (included Client SDK).
But Microsoft.SqlServer.ManagedDTS.dll is missing.
Where can I find the dll to reference this dll in a VB project?
Asked
Active
Viewed 1.1k times
2 Answers
12
I have it in C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS
Underneath that folder, you should see a specific folder for a given SQL Server version. If you go to that child folder, you can get the dll for that specific SQL Server.
Gordon Bell
- 13,337
- 3
- 45
- 64
Sam Kolli
- 391
- 3
- 8
-
I did find the dll there. However, I can't add a reference to it in the VB project. Visual Studio – Tom McDonald Jun 27 '17 at 14:07
-
I added an image above. I browsed to the dll and ticked the checkbox but it wouldn't add the reference. – Tom McDonald Jun 27 '17 at 14:10
-
OK, I had remove the reference to the missing ManagedDTS and then add a reference to the new dll location. I can see this is going to cause portability problems for development on non-SQL 2016 machines. – Tom McDonald Jun 27 '17 at 14:34
-
I also had to update the target framework to version 4.0 or greater to get it to compile. – Tom McDonald Jun 27 '17 at 14:41
-
On a different (Win7) machine I had the problem again. On the new machine I repeated the solution here and it didn't work. I got it to work adding the reference via the 'extensions' tab and that added a different dll (see the image) I added to the question – Tom McDonald Jul 05 '17 at 14:48
-
help me so much thenks – izik f May 13 '18 at 15:56
0
Old post, but just had this issue today after uninstalling some old 2008 bits. I had this same complaint from SSIS and what worked for me was to go through the Solution Explorer, right click Microsoft.SqlServer.ManagedDTS --> Properties and change "Specific Version" from True to False. This let it use the installed version.
