Where does BI sit

Hi guys,

I'm sure this is a silly question, but where do you create SSRS, SSAS, SSIS projects from? On my MSDN subscription I can see downloads such as 'SQL Server 2012 Business Intelligence with Service Pack 2'. However, when watching a video on SSAS they started a new project from within Visual Studio, I'm slightly confused, do you need BI setup on both the database and the development front end?

I am currently running Visual Studio 2013 Professional and Microsoft SQL Server 2014

Many Thanks,
Dean.
deanlee17Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Sorry, don't know, but I'm guessing it's SQL Server Data Tools
http://www.microsoft.com/en-us/download/details.aspx?id=42313
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Download and open Visual Studio 2012, which is essentially SQL Server Data Tools.

Then start a new project, and the New Project dialog should give you (in addition to a wompload of other stuff you won't use)

Installed >> Templates >> Business Intelligence >> Reporting Services (as well as IS and AS)
0
 
deanlee17Author Commented:
Hi Jim,

Thanks for the reply. Any idea why Visual Studio 2013 doesn't have this?
0
 
deanlee17Author Commented:
Thanks Jim.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade, good luck with getting it installed.  -Jim
0
All Courses

From novice to tech pro — start learning today.