'Could not load file or assembly 'Microsoft.SqlServer.ManagedDTS, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

I have created as SSSIS package in BIDS 2013 and deployed code on server with following configuration:

Window Server: 2012
SQL Server: 2014

SSIS is working fine. but when I change Server Configuration as below:

Window Server: 2008
SQL Server : 2012

I get the following error:

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

sql-serverssis


Solution 1:[1]

I had a similar problem in a different context. I solved mine by installing MS SQL Server 2014 Management Studio (SSMS 2014), which can be found here:

https://www.microsoft.com/en-us/download/details.aspx?id=46697

You can install the entire SSMS 2014 bundle, or select specific modules.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 woodvi

Related Questions