Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

This tutorial will help you to get started with SSIS (SQL Server Integration Services)

Getting started with SSIS

Getting started with SSIS - Part 2: BIDS Overview

Feb 7 2012 12:00AM by Sudeep Raj   

What is BIDS? Why do I need it? Where can I find it?

3 questions are asked here. Therefore, I will provide the 3 answers to you.

What is BIDS?

BIDS stands for Business Intelligence Development Studio. And this is what MSDN says about BIDS:

Business Intelligence Development Studio is Microsoft Visual Studio 2008 with additional project types that are specific to SQL Server business intelligence. Business Intelligence Development Studio is the primary environment that you will use to develop business solutions that include Analysis Services, Integration Services, and Reporting Services projects. Each project type supplies templates for creating the objects required for Business Intelligence Solutions, and provides a variety of designers, tools, and wizards to work with the objects.

Therefore, this definition from MSDN lays down the basics of what is BIDS. BIDS is an IDE (Integrated Development Environment) that is very similar to the basic look and feel of Visual Studios. It has been customized for Business Development Solution creation of MS BI Suite (SSAS, SSRS and SSIS). It does not have tools like textbox or buttons as you would see in Visual Studio. Instead, they comprise MSBI specific tasks, which enable us to create packages.

Why do I need it?

BIDS facilitates the entire development of solutions mentioned above. All you need to know is the business requirement and the basics of BI suite. The development need is highly reduced as a developer’s job can be summarized by DRAG, DROP, LINK & CONFIGURE the various tasks or transforms, as may be the case (I will elaborate them later). Talking specifically about SSIS, BIDS is the only way where you develop and test the SSIS package. SSIS package is nothing but a complex XML file. To make this xml file (package) and to modify the complex XML, we need BIDS. BIDS has lots of other features as well which we will be covering in the next chapter.

Where can I find BIDS?

You can get BIDS while installing MS SQL Server on your machine. While SQL Server installation on your machine follow the below steps and you will have BIDS on your machine.

Step 1

SQL Server Installation Centre

Step 2

SQL Server Installation Centre – New Installation

Step 3

SQL Server 2008 R2 Setup – Setup Support Rules

Step 4

SQL Server 2008 R2 Setup – Setup Support Files

Step 5

SQL Server 2008 R2 Setup – Setup Support details

Step 6

SQL Server 2008 R2 Setup – Installation Type

Step 7: Put a valid product key for your SQL server.

SQL Server 2008 R2 Setup – Product Key

Step 8: Accept the license terms

SQL Server 2008 R2 Setup – License Terms

Step 9: Setup the role as per your need

SQL Server 2008 R2 Setup –Setup Role

Step 10: While selecting the features select SQL Server Integration Services (You do not see here as it is already installed on my machine) and then from the shared services select the Business Intelligence Development Studio.

SQL Server 2008 R2 Setup – Feature Selection

After this step, you could proceed with your SQL Server installation. Once installed, you could start BIDS from Start->MS SQL Server -> SQL Server Business Intelligence Studio

When you open BIDS, it appears just like Visual Studios.

Start Page – Microsoft Visual Studio

The difference comes when you try creating a new project (File->New->Project).

Microsoft Visual Studio – New Business Intelligence Project

Here you will find the Business Intelligence Projects on the left pane and the various templates for MS BI development available. As of now, we would be concentrating on Integration Services Projects.

So, that sums up how to get BIDS on your machine. We will talk on how to use BIDS in the next article.

Sudeep Raj
12 · 13% · 4306



  • done with Part 2 ...waiting for the next

    commented on Feb 7 2012 9:03PM
    Manas Ranjan Dash
    39 · 5% · 1484
  • Hi Sudeep,

    Once again the way of presentation is simply superb

    To open BIDS in Run: Start-->Run-->Devenv or (Press Ctrl-R then type Devenv)


    commented on Jan 8 2013 4:45AM
    Bala Krishna
    84 · 2% · 676

Your Comment

Sign Up or Login to post a comment.

"Getting started with SSIS - Part 2: BIDS Overview" rated 5 out of 5 by 9 readers
Getting started with SSIS - Part 2: BIDS Overview , 5.0 out of 5 based on 9 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]