Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Problem starting SQL 2005 Business Intelligence Development Studio

Posted on 2011-03-09
9
Medium Priority
?
261 Views
Last Modified: 2012-06-27
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
Comment
Question by:lapucca
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35089273
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
 

Author Comment

by:lapucca
ID: 35089336
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
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35096211
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:lapucca
ID: 35097960
That link relates to someone with vs2005 installed.  I have vs2008.  thanks.
0
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35098108
I believe the BIDS project would still be included with the 2008 SQL Express as well.
0
 

Author Comment

by:lapucca
ID: 35098225
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
 
LVL 17

Expert Comment

by:Daniel Reynolds
ID: 35098451
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
 
LVL 17

Accepted Solution

by:
Daniel Reynolds earned 2000 total points
ID: 35098463
Even though it says Reporting Server projects, I believe that includes the realm of business intelligence projects (SSIS, etc)
0
 

Author Closing Comment

by:lapucca
ID: 35099968
Thank you.  At least now I know what are my limitations, even though there is no work around.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question