I have installed Microsoft SQL Server 2005.
This consists of the configuration tools (SQL server configuration manager, SQL Error and usage Reporting, SQL Server Surface area configuration, Reporting Services configuration) and SQL Server Management Studio.
However, I don't find SQL Server Business Intelligence Development Studio.
How can it be installed?
Is it available online as a freeware download?
To download the application, please click on this link: Microsoft Business Intelligence for Visual Studio, select the language (by default English is selected), and click the download button. Once the download completes, click on the SETUP will open the following windows.
To install it, go to Tools… Extensions and Updates… go to the Online tab and then search for BI Developer Extensions: You can also download it from the Visual Studio Marketplace in a web browser here. Ensure you have the latest version of SSDT installed for Visual Studio 2017.
It sounds like you have installed SQL Server 2005 Express Edition, which does not include SSIS or the Business Intelligence Development Studio.
BIDS is only provided with the (not free) Standard, Enterprise and Developer Editions.
EDIT
This information was correct for SQL Server 2005. Since SQL Server 2014, Developer Edition has been free. BIDS has been replaced by SQL Server Data Tools, a free plugin for Visual Studio (including the free Visual Studio Community Edition).
If you have installed SQL 2005 express edition and want to install BIDS (Business Intelligence Development Studio) then go to here Microsoft SQL Server 2005 Express Edition Toolkit
This has an option to install BIDS on my machine, and is the only way l could get hold of BIDS for SQL Server 2005 express edition.
Also this package l think has also allowed me to install both BIDS 2005 & 2008 express edition on the same machine.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With