sql serverssis
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.
The answer by baldy below is correct, but you may also need to enable 32-bit applications in your AppPool.
Whilst setting up an application to run on my local machine (running Vista 64bit) I encountered this error:
Could not load file or assembly
ChilkatDotNet2or one of its dependencies. An attempt was made to load a program with an incorrect format.
Obviously, the application uses ChilKat components, but it would seem that the version we are using, is only the 32bit version.
To resolve this error, I set my app pool in IIS to allow 32bit applications. Open up IIS Manager, right click on the app pool, and select Advanced Settings (See below)
Then set "Enable 32-bit Applications" to True.
All done!
Uncheck "Enable extended...". It will be removed in next version of VS. (Click on link 'More Information' next to it.)
Best Answer
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.