Integration services feature is not found in SQL Server 2008 R2 Express Edition?

0
votes

I want to install the following features in SQL Server 2008 R2:

  • BIDS (Business Intelligence Development Studio)
  • Integration Services

But setup is not showing me this feature in the installation window.

I downloaded SQL Server 2008 R2 Express edition from this link :

sql server 2008 r2

but I cant find Integration services feature in this setup.

help me with suggestion to install Integration services . Also provide with links to download sql server 2008 r2 enterprise edition

1
sql-serversql-server-2008ssissql-server-2008-r2
You need to make sure to download the SQL Server 2008 R2 Express with Advanced Services edition - the Advanced Services version does include the BIDS - marc_s
@marc_s , SQL Server 2008 R2 Express with Advanced Services edition does not support integration services . what can i do for that. - dheena
Buy a full version of SQL Server ..... - marc_s

1 Answers

1
votes

SQL Server Express does not supports Integration Services.

Business Intelligence Development Studio is not included into Express edition, but it is inculded into Express with Advanced Services edition.

See MSDN for comparison table of features supported by different editions of SQL Server.

You have to install at least Standard edition in order to be able to use Integration Services, but note - is is not free to use like Express edition.