asked
installation of sql server
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.
Sorry but AFAIK, SSIS do not come with SQL Express edition. You need to buy the higher versions like SQL Standard/Developer edition if you want to work with SSIS.
As I said before, you need to buy it. You can search google for that as some THIRD PARTIES do let download after the payment. But the best would be to contact MICROSOFT.
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:
Standard/Developer edition if you want to work with SSIS
