Running DFLD with SQL 2012: missing Microsoft.SqlServer.ManagedDTS assembly...

Jan 14, 2013 at 4:44 PM

I have SQL Server 2012 installed as the only version of SQL Server on my mashine. The application throws the following exception:

"Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass
embly 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, Public
KeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find th
e file specified.
File name: 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, P
ublicKeyToken=89845dcd8080cc91'
   at BA.SqlServer.Ssis.Dfl.CallDiscoverer.Main(String[] args)"

Any idea what can be done to remedy this - I tried to register the DLL manually, but that did not work...

Thank you very much in advance,

Dmytro

 

Coordinator
Jan 16, 2013 at 10:26 AM

Dmytro,

If you are using SQL Server 2012, check whether Microsoft.SQLServer.ManagedDTS.dll is available at  \Microsoft SQL Server\110\SDK\Assemblies folder. This dll is usually installed in GAC  (which is usually C:\Windows\assembly). Under normal circumstances you wouldn't have to do this manually and  it is taken care of during SQL Server installation. If that's not successful try installing the Shared Management Objects from SQL Server 2012 Feature Pack http://www.microsoft.com/en-au/download/details.aspx?id=29065 and try again

Apr 5, 2013 at 4:17 PM
Edited Apr 5, 2013 at 4:27 PM
I am getting the same error - I already have the SMO installed. I do not have the ManagedDTS.dll

edit: sorry I'm getting a different error on, not the same one listed here: Microsoft.SqlServer.DTSRuntimeWrap
Coordinator
Apr 9, 2013 at 4:57 PM
Andriychenko wrote:
I have SQL Server 2012 installed as the only version of SQL Server on my mashine. The application throws the following exception: "Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass embly 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, Public KeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find th e file specified. File name: 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, P ublicKeyToken=89845dcd8080cc91'    at BA.SqlServer.Ssis.Dfl.CallDiscoverer.Main(String[] args)" Any idea what can be done to remedy this - I tried to register the DLL manually, but that did not work... Thank you very much in advance, Dmytro  
Just uploaded a new release - DFLD-201304-R2 where I replaced path references that were pointing to GAC to use file path instead. Try downloading the new exe and let me know if that works.
Apr 13, 2013 at 2:21 PM



Apr 13, 2013 at 2:23 PM

Thank you ever so much, I will certainly do that, as soon as I get back to the office!



Jan 21, 2014 at 9:57 AM
Hi,

I've got the same problem. I have both SQL Server 2008 R2 and SQL Server 2012 installed. I can find the DLL in C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies (the version is not the one I'm looking for : V 11.0) but it doesn't exist in C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies.
I can fin the good one in C:\Windows\assembly.

I'm trying to run vb code in ssis 2008 R2, the same code run for one package but get the error in the second one.

I'm not sure you're solution above is the good one for me.
Dec 23, 2014 at 9:17 PM
I had to install the "Client Tools SDK" from SQL Server 2008 installation to get the assembly to show up for my 2008 BIDS setup. None of the other options worked.