Search code examples
sql-servervisual-studio-2012ssis32bit-64bitsql-server-data-tools

Why is my Run64BitRuntime flag ignored

I am using Visual Studio 2012 with SQL Server 2012 Data Tools installed. For some unexplained reason, my workstation will only run my SSIS code in 32 bit mode. Here is a dummy data flow I built for testing purposes:

enter image description here

Here are my settings:

enter image description here

It only runs DTSDebugHost.exe *32.

enter image description here

I am at my wits end trying to figure this one out. What do I do to figure out why it is not running just DTSDebugHost.exe (the 64 bit version)?

Solution

  • This happens because VS 2012 is checking to see if VS 2010 ULTIMATE is installed. It just looks for a registry entry.

    Solution:

    1. Open Regedit
    2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\vs\Servicing\11.0\
    3. Create a Key called premium
    4. Create a Key called ultimate
    5. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\vs\Servicing\10.0\
    6. Create a Key called premium
    7. Create a Key called ultimate

    Restart VS 2012.

    Now it should work in 64-bit mode when you debug.