?
Solved

Where are my bids templates?

Posted on 2010-09-13
13
Medium Priority
?
757 Views
Last Modified: 2013-11-26
I have SQL 2008 developer and visual studio 2010 ultimate installed on my laptop but cannot find any BI project types. I want to work with SSIS. What have I missed?
0
Comment
Question by:QPR
[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
  • 3
  • 3
  • +1
13 Comments
 
LVL 4

Expert Comment

by:timexist
ID: 33669435
0
 
LVL 29

Author Comment

by:QPR
ID: 33669477
I am using SQL 2008
0
 
LVL 30

Accepted Solution

by:
Reza Rad earned 1400 total points
ID: 33669540
>>BIDS is in sql server 2008 only.<<
Incorrect!
BIDS is in 2005 and 2008 versions of sql server.

>>I have SQL 2008 developer and visual studio 2010 ultimate installed on my laptop but cannot find any BI project types. I want to work with SSIS. What have I missed?<<
you should start BIDS from this address:
start-> programs-> microsoft sql server 2008 ( or 2005 ) -> SQL Server Business Intelligence Development Studio
now when you create new project you will see BI templates.

Note that you should installed BIDS before that in sql server setup.


0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
LVL 4

Expert Comment

by:timexist
ID: 33669605
>>BIDS is in sql server 2008 only.<<
Incorrect!
BIDS is in 2005 and 2008 versions of sql server.


This user only has sql 2008 developer edition and vs 2010,  so BIDS is only in sql server 2008 .
Nothing is wrong.

You are talking about something out of scope.
0
 
LVL 29

Author Comment

by:QPR
ID: 33669666
Timexist you are contradicting your own reply. You say bids is available for SQL 2008. I HAVE SQL 2008
0
 
LVL 10

Assisted Solution

by:james-ct16
james-ct16 earned 600 total points
ID: 33669670
Howdy

Just to provide a little more information about this as I faced exactly the same confusion. It would appear that the sql server 2008 team are out of step with the visual studio team. To my knowledge and much confusion it is not possible to develop and of BI solution types in Visual Studio 2010 you have to full back to Visual Studio 2008. the only good news is that as long as you chose to install the business intelligence studio as part of the install its exactly where reza rads states.

From the MS connect Site

"Visual Studio 2010 is designed to generate RDL 2008 format in the RDLC designer. If you want to author RDL 2010, you can use the Business Intelligence Development Studio.

As a result, this issue is by design.

Stella Chan
SQL Server Reporting Services"

James
0
 
LVL 4

Expert Comment

by:timexist
ID: 33669714
QPR, you have to install it.
pic.JPG
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33669720
James is right
As he mentioned , BIDS doesn't support in VS2010 .
maybe future versions of VS support this type of projects , but for now just you can use VS2008 or VS2005 for BI projects.

and there will be no need to install Visual Studio separately, because SQL Server install BIDS itself( you should check BIDS in setup of sql server)

@QPR:
did you tried my suggestion?
0
 
LVL 4

Expert Comment

by:timexist
ID: 33669732
what a drama :-)
0
 
LVL 29

Author Comment

by:QPR
ID: 33679621
hmmm although I installed SSIS when I installed SQL 2008, I didn't bother installing BIDS as I planned to install VS2010 and have previously created BI solutions with VS 2008 so didn't think it necessary. I will dig out the SQL 2008 install disk from work and bring it home to install BIDS. What a hassle!
Is BIDS available as a stand alone download/install? Would be quicker for me rather than waiting till back at work
0
 
LVL 10

Expert Comment

by:james-ct16
ID: 33679637
Howdy
From memory it is included in SQL Server Express Edition with Advanced Services. So just install the editor and you should be fine. I cant recall any Express limitations

James
0
 
LVL 4

Expert Comment

by:timexist
ID: 33679639
No,I don't think so.
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33679709
if your sql server edition is not express, you can choose CLIENT COMPONENTS in features list in sql server setup disk. and this will install BIDS too

0

Featured Post

How to Create Failover DNS Record Sets in Route 53

Route 53 has the ability to easily configure DNS record sets specifically for failover scenarios. These failover record sets can be configured to failover to full-blown deployments in other regions or to a static HTML page that informs your customers of the issue.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

800 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