I have both SQL Server 2012 Developer and Visual Studio 2012 Ultimate installed. I also installed the Sql Server Data Tools - BI package. I started a new project to transfer databases from an old machine to a new one. I selected the Transfer Database task. I set up the connections to the old and new servers, specified the databases and file locations. However, when attempting to run the package, it fails with the error: Method not found: 'Boolean Microsoft.SqlServer.DTS.Design.VisualStudio2012Utils.IsVisualStudio2012ProInstalled()'. Seeing this, I added a C# project with a reference to the Microsoft.SqlServer.DTS.Design namespace. Exploring this namespace, I found that there *is* a method called IsVisualStudio2012UltimateInstalled() but not the method referred to in the error message. Since Visual Studio Ultimate is a superset of Visual Studio Professional, either the namespace should include the method reported missing or the Transfer Database task of Integration Services should accept IsVisualStudio2012UltimateInstalled() as a proxy for the missing method.
As per http://stackoverflow.com/questions/24745396/isvisualstudio2012proinstalled-method-not-found-error-when-running-an-ssis-pac
running
-
Open the Developer Command Prompt for VS212 as Administrator
-
execute the command
cd "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies"
-
execute the command
gacutil /if Microsoft.SqlServer.Dts.Design.dll
-
restart Visual Studio
Fixes this issue
That did the trick. But why?
More importantly, why does VS Ultimate not work out of the box for this task?
- Edited by G Britton 11 hours 25 minutes ago
It happens in mixed installation scenarios, and/or when there are third party tools/addons to VS or SSMS installed.
If you can repro, please feel free to submit a bug to MS Connect.