• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Problem starting SQL 2005 Business Intelligence Development Studio

Hi,
I have windows 7 Enterprise, SQL 2005 Standard with SP3.  When I click to start BID, a pop up dialog say there is compaitility issue with "visual studio 2005" and wants me to down load sp for vs 2005.  Well, the problem is I have Visual Studio 2005, .net 3.5 on my PC.  I want to use SSIS to create a package.  How can I get pass this so it knows I have vs 2008 and use that instead?  Thanks.
0
lapucca
Asked:
lapucca
  • 5
  • 4
1 Solution
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
Just open up VS 2008 and choose to create a new project select Business Intelligence Project and the type of project you want to create.
0
 
lapuccaAuthor Commented:
I selected Other Project Types and there is only a DATABASE project.  I double click to search online for new templates and it returns nothing.  Thanks.
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
Check this link, it has some info for you to get the project types.
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/eb73f47c-e558-4a0e-9e63-3a3dfb3bc684
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
lapuccaAuthor Commented:
That link relates to someone with vs2005 installed.  I have vs2008.  thanks.
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
I believe the BIDS project would still be included with the 2008 SQL Express as well.
0
 
lapuccaAuthor Commented:
Right, I have sql 2005 standard installed but my VS is 2008.  So, the sql 2005 is looking for VS2005 for BID.  Any way around this?  thanks.
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
hmm. ok. got it.

The following link seems to point to the answer. Unfortunately not a very acceptable one.
Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)

http://geekswithblogs.net/juang/archive/2007/12/12/visual-studio-2008-will-not-support-sql-server-2005-reporting.aspx
0
 
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
Even though it says Reporting Server projects, I believe that includes the realm of business intelligence projects (SSIS, etc)
0
 
lapuccaAuthor Commented:
Thank you.  At least now I know what are my limitations, even though there is no work around.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now