Overview

Introduction

The Managing SSIS Package Execution module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Executing SSIS Packages using SQL Server Agent
  2. Executing SSIS Packages using SQL Server Management Studio and PowerShell Script
  3. Executing SSIS Packages using SSIS Utilities
  4. Validating SSIS Projects and Packages using SQL Server Management Studio

Exercise 1- Executing SSIS Packages using SQL Server Agent

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Schedule a package execution by creating a SQL Server Agent job
  • Execute a package using SQL Server Management Studio
  • Execute a package using PowerShell script

Exercise 2 - Executing SSIS Packages using SQL Server Management Studio and PowerShell Script

You can run your SSIS package on the SSIS server using SQL Server Management Studio by connecting to the instance of the SQL Server that contains the Integration Services catalog where the project is deployed.

In this task, you will execute the package Package.dtsx using the SQL Server Management Studio. To run the package in the SQL Server Management Studio, you need to deploy the package onto the SQL Server. For this, you will first create a catalog in the instance of the SQL Server to hold the deployed package package.dtsx. You will then deploy Package.dtsx in the newly created catalog and execute it.

Exercise 3 - Executing SSIS Packages using SSIS Utilities

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Execute a package using DTExec command prompt utility
  • Execute a package using DTExecUI graphical user interface utility

Exercise 4 - Validating SSIS Projects and Packages using SQL Server Management Studio

In this exercise, you will learn the following in Microsoft SQL Server 2012:

Validate and manage SSIS packages on the Integration Services server using SQL Server Management Studio

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.