This article introduces SQL Server Integration Services in Business Intelligence Development Studio (BIDS).

Introduction

Business Intelligence Development Studio is the environment that can be used to develop packages for data Extraction, Transfer and Load (ETL) in integration services. It can be used to create simple and complex packages.

Basically, integration services is a solution of one or more packages. It is a much richer feature of Business Intelligence Development Studio.

ssis

The integration services consist of several components including:

Integration services Solution Explorer

Solution Explorer provides an organized view of your project and their files as well as ready access to the commands that patterns to them.

integration services Solution Explorer contains the following four types of folders:

Data source folder

A data source folder defines a connection that can be shared among multiple packages in a project. You can create a connection manager in a package from an existing data source.

Data source views folder

A data source view folder defines a subset of the data in a data source and can contain named queries.

SSIS (SQL Server Integration Services) package folder

This folder represents a collection of connections, control flow elements, data flow elements and other objects. This folder contains these wizard types:

Miscellaneous folder

If you want to add other types of files to your integration services project then these types of folders are available in this folder.

Integration services designer

It is graphical tools that contain various types of designer tools for creating packages as in the following:

Control flow tab

In this graphic tool you can arrange and configure the task. In this tab, the data flow task provides functionality in packages and containers that provide structure in packages and services in tasks. These types of tasks are available in the integration services tool box.

Data flow tab

In this designer tab, you combine into a data flow sources that extract data, transformations that modify and aggregate data, destinations that load data. There are given paths that connect the outputs and inputs to data flow components.

Event handler tab

In this tab, we can configure workflows to respond to package events.

Package explorer tab

This package provides an explorer view of the package.

Progress tab

The progress tab can be used to display information about package execution when the package runs in the Business Intelligence Development Studio.

Connection managers area

Integration services use this tab to create a connection to a data source.

Integration services designer on tools menu

Under the Business Intelligence Designers node in the Options dialog box available on the Tools menu. There are the following three types of tools:

General page

In this page, you can specify options for loading, displaying and upgrading packages.

Control Flow Auto Connect and Data Flow Auto Connect pages

These two types of pages specify the default behavior for connecting objects that are available on the design area.

Confirm delete page

In this page, you can specify a confirmation message, when packages components are deleted.

Integration services project properties

Integration services project properties define the property of integrations services.

Integration services windows and feature

There are the following features of integration services.

Toolbox

The tool box has control flow tasks and data flow sources, transformations and destinations.

Variable Window

The variable window is near the toolbox but it may not be visible the first time you open an integration services project. SSIS menus displays the variable window. The variable window can be used to communicate objects in a package with each other.

Log event window

The variable window is near the toolbox but it may not be visible the first time you open an integration services project. SSIS menus display the variable window. This window can be used to keep the records of packages of runtime events.

Integration services package storage options

There are the following types of storage options.

Summary

This article describes an introduction to integration services of Business Intelligence Development Studio and also describes features and various types of designer tools.