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.
lapuccaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Daniel ReynoldsConnect With a Mentor Software Applications Developer / IntegratorCommented:
Even though it says Reporting Server projects, I believe that includes the realm of business intelligence projects (SSIS, etc)
0
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
 
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
 
lapuccaAuthor Commented:
Thank you.  At least now I know what are my limitations, even though there is no work around.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.