none
Fail to start project

    Question

  • Hi, everyone

    When I click start to run the project, there is a error message: 

    Failed to start project

    ------------------------------
    ADDITIONAL INFORMATION:

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

    I installed vs2012 iso and integrated, my version is 11.0.5058.0.

    Any help appreciate.

    Thursday, July 10, 2014 3:37 PM

Answers

  • FIXED!!

    Or, more to the point, bodged. Here's the steps...

    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

    This puts the older DLL in place of the new one. The problem is of course that you are now running an older version of the DLL which I guess might give some random problems and inconsistencies but hopefully it will get you up and running while Microsoft work out how to fix it properly.

    Dave


    Wednesday, July 16, 2014 10:17 AM

All replies

  • Perhaps you are missing the BI project templates so just opening a SSIS project in VS 2012 is not the way to go, otherwise see if this helps: http://blogs.msdn.com/b/jason_howell/archive/2010/08/18/visual-studio-2010-solution-build-process-give-a-warning-about-indirect-dependency-on-the-net-framework-assembly-due-to-ssis-references.aspx

    lastly, I suggest you apply SPs, CUs etc. If that does not help - reinstall all the developer tools.


    Arthur My Blog

    Thursday, July 10, 2014 3:51 PM
    Moderator
  • I am having the same exact issue. I have tried reinstalling using a utility to get rid of everything in the registry. Did the latest service pack updates for SQL 2012 and visual studio 2012 with no luck. This just happened all of a sudden and I can't figure out why.
    Sunday, July 13, 2014 5:50 AM
  • Hi there,

    I'm getting the same error too. I've reloaded my machine and tried installing from scratch and I'm also getting the same error as these guys.

    I am using Visual Studio 2012 Ultimate, SQL Server 2012, SQL Server Data Tools 2012 and SQL Server Data Tools for BI 2012, all patched to the latest version.

    The only thing I have done since the install and patching is to install Visual Studio 2013 Express for Window. Could this be confusing things? Perhaps the version detection is failing because it is detecting the wrong version of Visual Studio?

    Monday, July 14, 2014 11:31 AM
  • 1.I do have BI project templates.

    2.I installed SQL sever SP1 already

    3.re-installed everything.

    Still have same issue!

    Monday, July 14, 2014 2:57 PM
  • I am getting this same error.  It worked fine for me last week Thursday (7/10) and was broken today (7/14).  I rebooted my PC over the weekend and windows updates were installed, but aside from that I haven't changed anything that I'm aware of.

    Posted a question about this on Stack Overflow as well:

    http://stackoverflow.com/questions/24745396/isvisualstudio2012proinstalled-method-not-found-error-when-running-an-ssis-pac

    Monday, July 14, 2014 8:38 PM
  • I installed exact same things in another computer, and worked fine.

    So, I think the problem is computer! but I don't know how to fix it.

    Tuesday, July 15, 2014 2:51 PM
  • Hi Everyone,

    I have just reloaded my machine from scratch. I've only installed Office 2013, SQL Server 2012, Visual Studio 2012, the latest SQL Server Data Tools and the latest SQL Server Data Tools for BI. And after wasting an entire day I get exactly the same error. Here are the steps to reproduce...

    1) Take one HP machine with Intel i3 processor and 8GB ram

    2) Install Windows 8.1 64bit and then full Windows Update for all products, restart

    3) Install Windows 8.1 Update 1 then Windows Update all products, restart

    4) Enable windows features - IIS, Hyper-V and .NET 3.5 and Windows Update all products, restart

    5) Install Office Pro 2013 32bit

    6) Install Visio 2013 32bit and then Windows Update all products, restart

    7) Install SQL 2012 Developer 64bit with all options except Data Tools, update, restart

    8) Install Visual Studio 2012 Ultimate with all options except Data Tools, update, restart

    9) Install SQL Server Data Tools 11.1.40403.0 EN

    10) Install SQL Server Data Tools for BI VS2012 x86

    11) Install SQL Server 2012 Service Pack 2

    12) One final Windows Update with Microsoft Products and then a restart

    13) Unlucky 13, the SSIS packages open in the editor but trying to execute gives the error described here

    Tuesday, July 15, 2014 4:21 PM
  • Again, just a bit of info, I chose to run Visual Studio 2012 in General mode. I wondered if this cause the problem so ran a devenv /resetsettings with no luck. I then ran a devenv /resetuserdata and chose to use Visual Studio in Business Intelligence mode. Made no difference, still broken.
    Tuesday, July 15, 2014 4:50 PM
  • I have found that I have two different versions of Microsoft.SqlServer.Dts.Design.dll installed across four folders.

    C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.Dts.Design\v4.0_11.0.0.0__89845dcd8080cc91

    C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies

    C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio

    These all contain version 11.0.5058.0

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

    This folder contains version 11.0.3436.0. Perhaps Visual Studio is executing the wrong version?

    Tuesday, July 15, 2014 5:04 PM
  • Hi,

    I've checked my version of the of the dll in the GAC and this is the result...

    The Global Assembly Cache contains the following assemblies:
      Microsoft.SqlServer.Dts.Design, Version=11.0.0.0, Culture=neutral, PublicKeyTo
    ken=89845dcd8080cc91, processorArchitecture=MSIL

    Number of items = 1

    This appears to show it is using a version 11.0.0.0 but I'm not sure if this is correct? Any ideas?

    Wednesday, July 16, 2014 9:28 AM
  • Hi there once again,

    I've just created a small C# project on my machine.

    I've added a reference to the Microsoft.SqlServer.Dts.Design dll from the GAC in C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.Dts.Design\v4.0_11.0.0.0__89845dcd8080cc91

    When I use the Object Browser to view what methods are available I find that Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils.IsVisualStudio2012ProInstalled() doesn't exist because it has Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils.IsVisualStudio2012UltimateInstalled() instead.

    Using this process I've found the only version of the dll on my machine with the correct method available is the one in C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies

    Is the latest version of the BI tools compatible with Visual Studio 2012 Ultimate?

    Dave

    Wednesday, July 16, 2014 10:12 AM
  • FIXED!!

    Or, more to the point, bodged. Here's the steps...

    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

    This puts the older DLL in place of the new one. The problem is of course that you are now running an older version of the DLL which I guess might give some random problems and inconsistencies but hopefully it will get you up and running while Microsoft work out how to fix it properly.

    Dave


    Wednesday, July 16, 2014 10:17 AM
  • Brilliant! Had this same issue and this was the fix that finally worked.
    Thursday, July 17, 2014 7:18 PM
  • gacutil /if Microsoft.SqlServer.Dts.Design.dll doesn't replace the new assembly. It just adds Microsoft.SqlServer.Dts.Design, Version=10.0.0.0 to the GAC (Global Assembly Cache). My GAC already had Microsoft.SqlServer.Dts.Design, Version=11.0.0.0 added, so after adding version 10, I had 2 versions of the same assembly. However, when I removed version 11 from my GAC Visual Studio failed to start correctly complaining it couldn't find Microsoft.SqlServer.Dts.Design, Version=11.0.0.0. I've tried repairing and re-installing Visual Studio 2012 but it's still not working for me.

    Luis 


    • Edited by Luis Lema Wednesday, July 23, 2014 5:16 AM
    • Proposed as answer by Luis Lema Wednesday, July 23, 2014 9:57 PM
    • Unproposed as answer by Luis Lema Wednesday, July 23, 2014 9:57 PM
    Wednesday, July 23, 2014 5:15 AM
  • What did to make it work is to uninstall all versions of SQL server and Visual Studio, run CCleaner to clean the registry, install SQL Server 2012 without SSDT, install Visual Studio 2012 SSDT and then install 2012 BI templates. 
    Wednesday, July 23, 2014 9:59 PM
  • my gacutil was not in same place as Daves

    my process to fix:

    start cmd prompt run as administrator

    cd C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools

    gacutil /if "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\Microsoft.SqlServer.Dts.Design.dll"

    hope it helps someone


    HMSO

    • Proposed as answer by William Assaf Friday, August 29, 2014 7:17 PM
    Friday, August 22, 2014 2:24 AM
  • This option worked for me!!!

    Thanks,

    Thomas


    TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA

    Friday, August 22, 2014 4:28 PM
  • my gacutil was not in same place as Daves

    my process to fix:

    start cmd prompt run as administrator

    cd C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools

    gacutil /if "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\Microsoft.SqlServer.Dts.Design.dll"

    hope it helps someone


    HMSO

    This was also the case for me and fixed the issue. Note that in my case, I only had VS shell from the Data Tools for VS 2012 and Data Tools BI for VS2012 installed, not full version of VS.


    Friday, August 29, 2014 7:18 PM
  • Thank you! Thank you! Thank you!
    Monday, September 15, 2014 7:59 PM
  • These steps resolved the issue for me as well.  Thanks!

    Tim Mitchell | TimMitchell.net | @tim_mitchell

    Sunday, September 21, 2014 9:14 PM
  • Thanks for posting Dave, worked for me!
    Monday, September 22, 2014 1:08 PM
  • The second option worked for me, however I have to apply it after a reboot!  Is there a solution that persists through reboots of my PC?

    jbr

    Monday, September 29, 2014 9:55 PM
  • This answer is also referenced in the StackOverflow link above in this thread. I've tried this and while it works for me it doesn't fix it permanently. If I close VS2012 and re-open it I have to run the fix again!!

    Any thoughts?

    Tuesday, October 14, 2014 4:18 PM
  • my gacutil was not in same place as Daves

    my process to fix:

    start cmd prompt run as administrator

    cd C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools

    gacutil /if "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\Microsoft.SqlServer.Dts.Design.dll"

    hope it helps someone


    HMSO

    This worked for me!  You just saved me a few days!

    Thanks

    Tuesday, October 28, 2014 11:06 AM
  • Solved my problem. Thank you.
    Wednesday, November 5, 2014 7:57 AM
  • Nice.  This worked for me.  My gacutil was in a different location as well.  Thanks
    Friday, February 13, 2015 6:10 PM
  • Thanks!
    Wednesday, March 4, 2015 1:34 AM
  • My issue was resolved by closing Visual Studio 2010 that I had open at the same time.  When I only had VS2012 open, it worked without issue.
    Wednesday, March 25, 2015 5:50 PM
  • i have same issue

    i went to cmd and run this but getting error:

    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

    C:\Windows\system32>cd..

    C:\Windows>cd..

    C:\>cd C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools

    C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>gacutil
    /if "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAsse
    mblies\Microsoft.SqlServer.Dts.Design.dll
    Microsoft (R) .NET Global Assembly Cache Utility.  Version 4.0.30319.18020
    Copyright (c) Microsoft Corporation.  All rights reserved.

    Failure adding assembly to the cache: Administrator permissions are needed to us
    e the selected options. Use an administrator command prompt to complete these ta
    sks.

    C:\Program Files (x86)\Microsoft SDKs\Windows\v8.0A\bin\NETFX 4.0 Tools>^A^A

    any solution?what i need to do

    Tuesday, March 31, 2015 8:12 PM
  • coool_sweet, Key here is the below: "Administrator permissions are needed to use the selected options. Use an administrator command prompt to complete these tasks."

    You need to launch cmd prompt with "run as administrator"

    Tuesday, March 31, 2015 9:07 PM
  • Worked for me :) 

    My problem appeared after SP1 for SQL Server 2014 on VS 2013 Ultimate.

    Wednesday, September 16, 2015 10:47 AM
  • I have installed Microsoft SDK and run the above command and it worked fine.....
    Sunday, March 6, 2016 8:43 AM