hi i need to know which version of sql server should be installed as i want to work on integration services i.e SSIS and SSMS I installed the express edition but it does not contain the integration service template. from where should i download. please suggest me the download link.i hv a windows 7 OS of 64 bit.
If you need BIDS functionality, then you'll need to buy one of the other editions of SQL Server - I would suggest the Developer edition, as it's cheap and contains all the functionality, but with limited licensing. For a comparison of what the different editions of SQL Server 2008 R2 contain, have a play with this page: You can download an evaluation version of SQL Server 2008 R2, And this page contains information on who to contact to purchase a copy: