SSIS Method Not Found

In recent work using Visual Studio 2012 creating SSIS packages, the following error was encountered:

1_IsVisualStudio2012ProInstalled

 

I was able to temporarily solve this error using the following steps:

(1) Open the Developer Command Prompt in Visual Studio 2012 as Administrator.

Because the Developer Command Prompt wasn’t immediately visible on my Windows 8.1 system, some additional steps were required.

    • Press the Window button on your system. In the Start window locate the Search field and type “Developer Command Prompt for VS2012”.
    • Locate the Search result for the Developer Command Prompt, right-click, and select Pin to Start.
    • Now right click on the Developer Command Prompt for VS2012 tile and select Run as Administrator.
    • Select Yes if the User Account Control prompt appears.

(2) Execute the commands (note you can do this as a single command):

  • cd C:\Program Files (x86)
  • cd Microsoft Visual Studio 11.0
  • cd Common7
  • cd IDE
  • cd PrivateAssemblies

With the execution of these commands, you should be located at

C:\Program Files (x86)\VisualStudio 11.0\Common7\IDE\PrivateAssemblies

ExecuteCommands_PrivateAssembliesDirector

(3) Execute the command gacutil /if Microsoft.SqlServer.Dts.Design.dll:

GacUtilCmdjpg

This loads the DLL to the Global Assembly Cache. It replaces the older DLL with the new one.

I continue to look for a more robust reason and ultimate fix on this issue. Once I locate it, I will augment this post with those findings.

The primary steps in this post, were obtained from the post Fail to Start Project.

Regards

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.