[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

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
0
WLMN
Asked:
WLMN
  • 7
  • 6
2 Solutions
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now