• Article

Exploring SQL Server 2012 Integration Services (RTM Update)

Version: 1.4

Description

In this lab, you will commence by exploring a partially completed Integration Services project designed to populate the Adventure Works data warehouse. You will explore the design of the packages and specifically the use of a project connection manager and package parameters - both being new features in Integration Services for SQL Server 2012.

Overview

In this lab, you will commence by exploring a partially completed Integration Services project designed to populate the Adventure Works data warehouse. You will explore the design of the packages and specifically the use of a project connection manager and package parameters – both being new features in Integration Services for SQL Server 2012.

Next you will create the SSIS Catalog and then deploy the project to this catalog. Once deployed you will execute the Master package and review the execution results using the dashboard and standard reports.

Objectives

The objectives of this lab are to:

  • Introduce project connection managers
  • Introduce parameters
  • Create a SSIS Catalog
  • Deploy an Integration Services project to the SSIS Catalog
  • Execute packages from the SSIS Catalog
  • Script package execution commands
  • Monitoring the Integration Services environment and package executions

System Requirements

You must have installed the following items to complete this lab:

  • Microsoft SQL Server 2012:
    • Database Engine
    • Integration Services
    • SQL Server Management Studio
    • SQL Server Business Intelligence Development Studio
  • Adventure Works for SQL Server 2012
    • AdventureWorksDW2012

Setup

The setup and configuration for this lab involves running a Setup script included with the training kit. To run all setup tasks for this lab:

Note:
This process may require administrative privileges.
  1. Open a Windows Explorer window and browse to the lab’s Source folder.
  2. Double-click the Setup.cmd file in this folder to launch the setup script and run all setup tasks for this lab.
  3. If the User Account Control dialog is shown, confirm the action to proceed.

Cleanup

  1. There is no need to cleanup if you intend to continue the sequence of labs in this training kit.
  2. To restore the original state of the AdventureWorksDW2012 database, open a Windows Explorer window and browse to the lab’s Source\Setup folder.
  3. Double-click the Cleanup.cmd file in this folder to launch the cleanup script.
  4. If the User Account Control dialog is shown, confirm the action to proceed.

Exercises

This lab comprises the following exercises:

  1. Exploring the Integration Services Project
  2. Deploying and Managing the Integration Services Project

Estimated time to complete this lab: 30 minutes

Feedback

Your feedback is welcome! Please, post it on our UserVoice forums.

next >

Downloads

Download The Offline Training Kit
Download Hands-on Lab Document (DOCX)
Download Hands-on Lab Source Files

Contents