


Installing BIDS has no prerequisite on Visual Studio or SSDT and SSDT has no influence whatsoever on the installer you are running.Īlso, BIDS is by definition Visual Studio 2008 as explained hereīusiness Intelligence Development Studio is Microsoft Visual StudioĢ008 with additional project types that are specific to SQL Server Everything was just working fine and then suddenly a requirement came for DTSX package and I was searching everything i.e Microsoft Visual Shell I didn’t find anything anywhere and I searched on Google and then found that for BIDS (Business Intelligence development studio you need. Have a look at Features Supported by the Editions of SQL Server 2008 R2 which clearly states that the regular express doesn't have BIDS and the Express with advanced services does have BIDS. I had recently download SQL server 2014 standard edition in SQL Server 2014 and all its features are installed. SQL Server Management Studio for Business Intelligence To access, configure, manage, and administer Analysis Services, Integration Services, and Reporting Services, use SQL Server Management Studio.
Microsoft sql business intelligence development studio install#
Make sure you install the Microsoft SQL Server2008 R2 RTM - Express with Advanced Services as that is the only one including BIDS. From your screenshot I judge that you are using the Express installer (It says: Select the express features to install), SSDT and Visual Studio 2010 have no influence on the options in this installer. Then I try to install Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013, but I still didnt find the Business Intelligence.
