Can I use Business Intelligence Development Studio with SQL Server 2008 R2 Express Edition? Or is it available for Enterprise and Developer editions? If possible, have a standalone BIDS package?
According to the link below, MSDN Business Intelligence Development Studio (BIDS)is available in SQL Server 2008 R2 Express with Advanced Services.
Business Intelligence Development Studio (BIDS)
Features Supported by SQL Server 2008 R2 Editions - Development Tools
You can download Express using advanced services from the link below. Note that there are versions 32-bitand 64-bitto install. You need to choose the correct version.
32-bit
64-bit
RTM Microsoft SQL Server2008 R2 - Express
Express Advanced Services. , , BI- Express.