Solved

Problem starting SQL 2005 Business Intelligence Development Studio

Posted on 2011-03-09
9
253 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
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 500 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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