Solved

Problem starting SQL 2005 Business Intelligence Development Studio

Posted on 2011-03-09
9
252 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
spx for moving values to new table 5 74
T-SQL to Update Table Dynamically 2 47
sql query help 2 51
Sql Server group by 10 26
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
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 tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

786 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