how can I ensure that Inteligence Business Management is installed as part of Microsoft Visual Studio 2005?

Hi people,

I need to access and create a Business Intelligence project in Microsoft Visual 2005 in order to Export SQL Server data to an Excel file using SSIS and Visual Studio as described here :
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23870332.html 
I've installed Microsoft Visual Studio 2005 Pro on my computer but for some reason I could not find "Using the sub-menu item Open, you can create a project, a website, or a file. Click on File | New | Project to create a new project. This opens the New Project window as shown in the following screenshot:"
I can not figure out What I am doing wrong or I installed the application not properly.
Why I can access or find File | New | Project to create a new project
Any help is much appreciated.

BIP.JPG
WLMNAsked:
Who is Participating?
 
nmcdermaidConnect With a Mentor Commented:
extract all data from an sql data file (stored on liitle data base on a USB memory stick) into an excel sheet.

1. Attach the database file (I assume it is .MDF) to your database server (using SQL Server Management Studio, which you amy have to install)
2. Browse to the table(s) you want in SQL Server Management Studio, copy and paste the data into Excel
Thats for a once off copy. If you want this to be an automated repeatable process then it may be worth using SSIS.
 
0
 
PedroCGDCommented:
You installed the Business Intelligence Module that is included with SQL Server?
Regards!
pedro
0
 
WLMNAuthor Commented:
Hi,
I've installed Microsft Visual 2005 Pro that includes SQL  Server 2005.
How can I check if Business intelligence Module is installed?
If I find out that is not installed what do I need to do?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
PedroCGDCommented:
Check on your machine the services installed.
Check attached image!
helped?
Regards!

Pedro
www.pedrocgd.blogspot.com
BIServices.JPG
0
 
WLMNAuthor Commented:
Hi,
Thanks for your help.
I checked the SQL services and found that few of them are missing . what shall I do next?
Sql-Services.JPG
0
 
WLMNAuthor Commented:
Hi,
thanks again Pedro.
So...you are telling me that I need to install the Sql 2005 enterprise edition in order to get Sql 2005 Analysis Services/Reporting?
does the enterprise edition run on XP?
0
 
WLMNAuthor Commented:
I would really appreciate if you can help on how to extract all data from an sql data file (stored on liitle data base on a USB memory stick) into an excel sheet.
I need to how can I do that step by step as this is my first time dealing with Sql 2005 files!
0
 
PedroCGDCommented:
try to use import/export wizard of the SQL Server.
0
 
WLMNAuthor Commented:
Hi,
Before trying to use import/export od the Sql Server could you tell me which version of Sql 2005 server I need to install on my XP computer in order to do that?
I've installed express edition on my XP Pro computer that does not give me the option to import/export.
0
 
PedroCGDCommented:
all except Express! :-)
ImportExport-Editions.JPG
0
 
WLMNAuthor Commented:
Hi,
Thanks once again Pedro.
I will download and install one of the versions you advised me to....and will let you know about the outcome of this.
0
 
PedroCGDCommented:
Good!
Give feedback after!
regards!
0
 
WLMNAuthor Commented:
Hi people,
I,ve managed to extract all data into an excel sheet as follows:
1. Attach the database file (I assume it is .MDF) to your database server (using SQL Server Management Studio, which you amy have to install)

2. Browse to the table(s) you want in SQL Server Management Studio, copy and paste the data into Excel

Thanks people for your help and I am going to give the points to both of you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.