CODEWITHSUNDEEP
sql-server-2012sql-server-2012-datatools
ErickTreetops
ErickTreetops

Reputation: 3375

SQL Server 2012 - SQL Server Data Tools

I have VS2012 Ultimate installed. In the Installed products it states I have SQL Server Data Tools 11.1. When I go to SQL Server 2012 and click on the SQL Server Data Tools Menu option, VS2010 starts up.

I changed the target to point to C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe instead of C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe

So now VS2012 starts up but under new projects I DO NOT have the option to create a new SSIS package. Nor the option to download the data tools off the web.

I did go through VS2010 and download DataTools for 2010 and also selected the download for 2012. VS2010 now has Business Intelligence but VS2012 still does not have this template.

Please help. Slowly going mad.

Upvotes: 0

Views: 5678

Answers (3)

Patricio Moraga
Patricio Moraga

Reputation: 49

New download and more compatibility languages as of January 2019.

SQL Server Data Tools in Visual Studio 2012

Supported Operating Systems:

  • Windows 10 (x86 and x64)
  • Windows 8, 8.1 (x86 and x64)
  • Windows 7 SP1 (x86 and x64)
  • Windows Server 2012 (x64), R2 (x64)
  • Windows Server 2008 R2 SP1 (x64)

Upvotes: 1

vincent jacquel
vincent jacquel

Reputation: 5107

SQL Server Data Tools part for Business Intelligence (SSAS, SSIS, SSRS) has been released as an add-on for Visual Studio 2012 in March 2013.

It can be downloaded here

If you are running on a 64 bit system and have any error message, use option 1 during the installation (New install). It will only add the BI Studio and not try to reinstall anything else.

Upvotes: 5

steoleary
steoleary

Reputation: 9278

Cnfusingly Microsoft have 2 different products called SQL server data tools, the one from the installation media which gives you the BI templates in VS2010 and one that you can download, which just adds the database project type to VS2010/12. Currently there are no BI templates available for VS2012, which is incredibly frustrating, it's due to the version of the Visual Studio Shell used by the tools on the installer only supporting 2010. I guess we'll just have to wait for an update to that :(

Upvotes: 1

Related Questions