Could not load file or assembly microsoft.sqlserver.manageddts error causing trouble? Read on to find out how to fix the issue. 

At Bobcares, we offer solutions for every query, big and small, as a part of our SQL Server Support.

Let’s take a look at how our SQL Server Support Team is ready to help customers resolve the “Could not load file or assembly microsoft.sqlserver.manageddts” error

How to resolve the “Could not load file or assembly microsoft.sqlserver.manageddts” error

Every now and then, some of our customers run into the following error message when they try to deploy an SSIS package via the Jet Data Manager:

Could not load file or assembly microsoft.sqlserver.manageddts

As per our SQL Server experts, this error often pops up if SQL Server Integration Services is not installed on the machine.

To begin with, first, let’s check whether we have SQL Server Integration Services installed. In order to do that, navigate to Start > Run > Services.msc > OK. Then locate the SQL Server Integration Services service and ensure it is running.

However, if Integration Services is not present, we have to go ahead with the installation to avoid the “Could not load file or assembly microsoft.sqlserver.manageddts” error in the future.

Alternatively, we can also choose to disable SQL Server Integration Services. In this scenario, Jet Data Manager will use ado.net by default.

Furthermore, our SQL server experts would like to point out that, while referencing Microsoft.SqlServer.ManagedDTS we have to compile for a specific version. In case we upgrade SQL, we have to upgrade the code as well as change the references to avoid running into trouble.

We can verify the version by checking the TargetServerVersion property. This is done by right-clicking on the project and navigating to Properties > Configuration properties > General.

We trust that our SQL server specialists’ troubleshooting tips will help you fix the problem. If you are still facing the “Could not load file or assembly microsoft.sqlserver.manageddts” error, we are just a click away.

[Need assistance with another query? We are available 24/7.]

Conclusion

In a nutshell, our SQL Server Support Engineers demonstrated how to resolve “Could not load file or assembly microsoft.sqlserver.manageddts” error.