KB2881285 - You cannot change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools in SQL Server 2012 or SQL Server 2014

Applies To
SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Standard SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use)

Symptoms

You have Microsoft Visual Studio 2010 Ultimate or Professional installed on a server. When you try to change the Run64BitRuntime property of an Integration Services project by using the SQL Server Data Tools (SSDT), you find the property is disabled and cannot be changed.

Note To locate the Run64BitRuntime property, see the Debugging page under the properties of the project.

Resolution

This problem was first fixed in the following cumulative update for SQL Server:

Cumulative Update 1 for SQL Server 2012 SP2 /en-us/help/2976982

Cumulative Update 10 for SQL Server 2012 SP1 /en-us/help/2954099

Cumulative Update 1 for SQL Server 2014 /en-us/help/2931693

Cumulative Update 7 for SQL Server 2012 SP1 /en-us/help/2894115

Note The 64-bit runtime is loaded only if you have the the previously mentioned fix installed and the following conditions are met. Otherwise, the 32-bit runtime is loaded.

  • Run64BitRuntime is chosen.
  • The Ultimate edition of Microsoft Visual Studio 2012 is present.
  • The 64-bit runtime is present.

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

      

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

See the terminology Microsoft uses to describe software updates.