Looking for Microsoft.SqlServer.ManagedDTS version 10

Question

I'm trying to reference Microsoft.SqlServer.ManagedDTS, which allegedly is to be found in Program Files\Microsoft SQL Server\100\SDK\Assemblies.  Except it isn't.  Nor is it anywhere on the machine.  I know that Integration Services is installed and running - my packages run just fine out of BIDS and via dtexec.  Yet I can't find the stupid dll.

I am not able to reference the ManagedDTS assembly from the GAC either.   Nor is the dll findable on the Servers which have had Sql Server 2008 and SP1 installed.

I have been using the 2008 Client tools  and BIDS 2008.

Clearly I've missed something.  Any ideas?

Answer 1

Did you check C:\Program files\Microsoft SQL Server\100\DTS\Binn ?

Answer 2

You can find the assebly in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies folder.

Note: I am using SQL Server 2008.



Cheers!!
M.

Answer 3

Note that if you are using an x64 machine, it may be under Program Files (x86).

 "C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll"

---

John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com

Answer 4

I have searched the entire hard drive and the registry for the dll but there is no sign of it.

Answer 5

I have searched the entire hard drive and the registry for the dll but there is no sign of it.

Answer 6

Eric,
try this link http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/c333d8e5-a4ca-470e-a2d8-4f67a5e05a10/

It seems they also face the same problem like yours.

---

Thanks, Bharani M - Please mark the post as answered if it answers your question. - Please vote the post as Helpful if you find the post as helpful.

Answer 7

Bharani, I see that the issue was related to sql2005 , and it was resolved by installing the SDK for SQL server 2005, and I remember doing that myself some time ago. But I cannot find an sdk install for SQL Server 2008. Thanks, Eric

Answer 8

My Mistake.

---

Thanks, Bharani M - Please mark the post as answered if it answers your question. - Please vote the post as Helpful if you find the post as helpful.

Answer 9

If anyone has the DLL's , how did you get them?

Answer 10

Well I found that you can add a feature in the Install called Client Tools SDK.   That installed the DLL and now I'm Good.