Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

IsVisualStudio2012ProInstalled() method not found error when running an SSIS package from VS2012

I'm trying to run an SSIS package in Visual Studio 2012. When I click the "Start" button I get this very odd error in a popup from Visual Studio:

Method not found: 'Boolean  Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils.IsVisualStudio2012ProInstalled()'.  (Microsoft.DataTransformationServices.VsIntegration) 

Clicking on the show technical information, I get this stack trace:

===================================  Failed to start project (Microsoft Visual Studio)  ===================================  Method not found: 'Boolean Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils.IsVisualStudio2012ProInstalled()'. (Microsoft.DataTransformationServices.VsIntegration)  ------------------------------ Program Location:     at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)    at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)    at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options) 

Has anyone ever seen this error before or know what the issue might be? A bit of googling turned up absolutely nothing for me.

I was able to happily develop and run SSIS packages from Visual Studio 2012 without any issues just a couple days ago (I did reboot my PC over the weekend and some windows updates were installed)

ETA:

I was able to find a couple very recent technet posts about this here and here so I suspect this was something that broke in an update over the weekend. One post says he solved the issue by reinstalling, but of course I'd rather not go that route if I don't have to.

like image 925
Eric Petroelje Avatar asked Jul 14 '14 20:07

Eric Petroelje


People also ask

How do I run SSIS package as administrator in Visual Studio?

To do this, click Start, point to All Programs, point to SQL Server 2005 or SQL Server 2008, right-click the tool you are using and then click Run as administrator. This launches the application with elevated privileges of the Built In Administrator account and the package executes successfully.

How do I edit SSIS packages in Visual Studio?

Editing the SSIS package. 1 Open SQL Server Management Studio, and select the Server on which the SSIS package you want to edit is stored. 2 Expand the Data Transformation Services folder, so that you can see the SSIS packages. 3 Double-click the SSIS package you want to edit.

How do I view SSIS packages in Visual Studio?

In Visual Studio, click New > Project on the File menu. In the Installed Templates area of the New Project window, expand Business Intelligence, and click Integration Services. Select Integration Services Import Project Wizard from the project types list.

How do I create a SSIS project in Visual Studio 2013?

In Visual Studio, select File > New > Project to create a new Integration Services project. In the New Project dialog box, expand the Business Intelligence node under Installed, and select Integration Services Project in the Templates pane. In the Name box, change the default name to SSIS Tutorial.


1 Answers

  1. Open the Developer Command Prompt for VS212 as Administrator

  2. execute the command cd "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies"

  3. execute the command gacutil /if Microsoft.SqlServer.Dts.Design.dll

  4. restart Visual Studio

Source msdn Fail to start project

For visual Studio 2013 execute the command cd "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies" in point 2 and then execute point 3 and 4.

like image 174
Albert Avatar answered Sep 22 '22 22:09

Albert