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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
PedroCGDCommented:
Check on your machine the services installed.
Check attached image!
helped?
Regards!

Pedro
www.pedrocgd.blogspot.com
BIServices.JPG
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
nmcdermaidCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.