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.
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.
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.
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.
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
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/eb73f47c-e558-4a0e-9e63-3a3dfb3bc684
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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. At least now I know what are my limitations, even though there is no work around.