Integrated Services in MS SQL Server

Integrated services help implement ETL (Extraction, Transform and Load data) and administrator jobs. BIDS (Business Intelligence Studio until 2008 R2 version) and SSDT (SQL Server Data Tools from 2012 later) are the environments for this service.

SSIS Basic Architecture

Solution (a set of projects) → Project (a set of packages) → Package (a set of tasks for ETL and administrators).

Each package can include components:

• Control Flow (Containers and Tasks)
• Data Flow (Source, Transformation and Destination)
• Event Handler (send message, Email)
• Package Explorer (see all in 1 package)
• Parameter (user interaction)

Here are the steps to open BIDS / SSDT.

Step 1 - Open the BIDS or SSDT from the MS SQL Server program group. The screen below will appear.

Opened SSDT screen

Step 2 - Go to File in the left corner and select New > Project to open the screen below.

Select the new Project

Step 3 - Select Integration Service under Business Intelligence in the upper left corner of the screen above to get the screen below.

Integration Service opened

Next lesson: Analysis services in MS SQL Server