Introduction

BIDS is the interface that you can use to develop packages for data Extraction, Transformation and Loading (ETL) in SSIS.

SQL Server Database Tooling

For more information: Microsoft SQL Server Data Tools Update.

The main features of BIDS are:

1. Solution Explorer

When we create a new project the Solution Explorer will create it and its contents are in three folders like Connection Managers, SSIS packages, Miscellaneous and one item like project.param.

Connection Managers

We have the options to create various types of connection managers to connect with different data sources and also this has the scope at package level and project level.

new connection manager

SSIS packages

This folder mainly contains the packages and has other items as shown in the following image.

ssis packages

We have the options to create a new package, package upgrade, import and export and add an existing package.

The Miscellaneous folder is used if you want to add any other file like documents, images and so on, you can use this folder.

project.param

Using this you can create a package parameter for modifying package execution without the necessity to edit and redeploy the package and project parameter to supply any external input the project receives to one or more packages in the project.

But in the old version the folder names are Data Sources, Data Source Views, SSIS Packages and Miscellaneous.

You can see in the following the difference in various versions.

package

test app

2. SSIS Designer

It mainly contains the following item tabs:

control flow

Control flow: This contains all the task and business logic in the package. We have the option to use the breakpoint for debugging and layout options for zoom in and zoom out.

Data flow: On the Data Flow tab, we have the options to combine into a data flow sources that extract data, transformations that modify and aggregate data.

Event handler: Configure workflows to respond to package events.

Package explorer: Explorer view of the package the views like top hierarchy, connections, executables, event handlers, logs, precedence constraints and variable configured in the package.

Progress: Information about package execution when you run a package.

Execution results: Summary of the execution with events details and errors if exist.

Connection Managers: Integration Services uses connection managers to encapsulate connections to a data source.

new OLEDB Connection

3. SSIS Menu

The following are the menu items:

debug progress reporting

4. SSIS Designer Options on the Tools Menu

Click on Tools =>Options => Business Intelligence Designers, there are the following types of tools:

Integration services designers

New version:

business intelligence designers

5. Integration Services Project Properties

The following are common properties and configuration properties:

simple app property page

6. Other Integration Services Windows and Features

Conclusion

This article explained the detailed options and menu items of BIDS.