Could not load file or assembly Microsoft.SqlServer.ManagedDTS

Question

_{Tuesday, May 13, 2014 2:45 PM}

I'm developing a website that will run a MS SQL Server SSIS package when a button on a webpage is operated.  The site is hosted on the same windows 2008 r2 server that hosts the SQL Server with the SSIS package.  I'm developing in Visual Studio 2012 premium on a windows 7 client.  In my project references I have added the reference to Microsoft.SqlServer.ManagedDTS and in the web.config for the project there is <add assembly="Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/> as expected.  The site build and publish to the server works without errors or warnings.

When I try to access the site from a client machine it errors out.  When I access it through a MS IE on the server it presents the error ...

Parser Error Message: Could not load file or assembly
'Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot
find the file specified.

I can access the page when debugging from VS 2012 .  I found the Microsoft.SqlServer.ManagedDTS.dll on my development client machine and moved it into he \bin folder in the sites directory in inetpub on the hosting server and then I can access the page without error... but of course after each publish from the development client have to move the dll over again.

I was expecting the add of the reference to cause the dll to become part of the site build and publish to the site each time it was done.

How can I get the build and publish to include the reference I have added to the project for Microsoft.SqlServer.ManagedDTS ?

If I'm missing something basic please excuse I'm still a bit of a newbie,

Thanks tonnes in advance for any help, Roscoe

All replies (4)

_{Wednesday, May 14, 2014 10:42 PM ✅Answered}

Hi Roscoe,

Thanks for your feedback.

rpfinnimore

I want to have the assembly include in the publish...which is what I thought adding the reference to the project was supposed to do no? 

For this issue,  you could give a reference to Microsoft.SqlServer.ManagedDTS in your project. Please take a look at the discussion in SQL Server forum.

Cannot use the Microsoft.SQLServer.ManagedDTS.dll

In addition, you could also consider getting help or search relevant discussions from SQL Server forum, I think it's also available for you.

hope it helps.

Regards

_{Tuesday, May 13, 2014 11:34 PM}

Hi,

Welcome to asp.net forum.

Parser Error Message: Could not load file or assembly  'Microsoft.SqlServer.ManagedDTS, Version=11.0.0.0, Culture=neutral,  PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot  find the file specified.

According to your description above, please follow the steps below, and check whether it helps you.

1. Run C:\Windows\assembly\gac_msil in the Run box from Start
2. Find the dll in folder Microsoft.SqlServer.ManagedDTS
3. Copy the dll

Regards

Angie

_{Wednesday, May 14, 2014 8:51 AM}

Hi Angie, Thanks for the reply,

I am currently copying the dll to the site folder in inetpub on the webserver hosting my site and that does work but I don't want to have to do that every time I publish my site to the server.  I want to have the assembly include in the publish...which is what I thought adding the reference to the project was supposed to do no?  What do I need to do to have the dll included in the publish so I don't have to copy it over every time?  Or am I missing the point of your response?

Thanks for any help, Roscoe

_{Wednesday, May 14, 2014 11:16 AM}

...further it lets the page appear but when the button is operated more exceptions are raised...Thanks Roscoe