Urgent help regarding SS2005 and VS2005

• swenri

  SSC-Addicted

  Points: 469

  More actions

  May 22, 2008 at 1:17 pm

  #121657

  Hello All,

  I've a question regarding VS 2005 and SSIS (BIDS -- Business Intelligence Development Studio)

  I will be moving the existing databases from MS-Access 2003 to Sql Server 2005. My question is I've VS 2005 installed on my system. How do I obtain access to Sql Server 2005 , SSIS and SSRS. I mean BIDS using VS 2005?

  Does Sql Server Express edition which comes with VS 2005 give me access to work with SSRS and SSIS? There is Sql Server 2005 installed on the server. I need to access it using VS2005 but, I'm unable to . Can anyone give me any suggestions please ?

  Looking for an early reply.

  Thanks,

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  May 23, 2008 at 4:00 am

  #819561

  hey,

  You may want to have a peek at the following article, which will show you what you get with the express edition:

  http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

  The answer is no, you cannot run SSIS from Express Edition, and that you will have seriously limited Reporting capablility "out of the box"

  For SSIS with Basic Transforms included, the minimum would be Standard Edition

  ~PD