Link to home
Start Free TrialLog in
Avatar of lapucca
lapucca

asked on

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.
Avatar of Daniel Reynolds
Daniel Reynolds
Flag of United States of America image

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.
Avatar of lapucca
lapucca

ASKER

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.
Avatar of lapucca

ASKER

That link relates to someone with vs2005 installed.  I have vs2008.  thanks.
I believe the BIDS project would still be included with the 2008 SQL Express as well.
Avatar of lapucca

ASKER

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.
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
ASKER CERTIFIED SOLUTION
Avatar of Daniel Reynolds
Daniel Reynolds
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lapucca

ASKER

Thank you.  At least now I know what are my limitations, even though there is no work around.