Course Details

Previous Page


SSIS Package Execution and Script Tasks


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Microsoft SQL Server Integration Services (SSIS) is a platform that can be used to build packages for data warehousing. This course will demonstrate how to create simple SSIS packages and also explain script tasks.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
none

Expected Duration (hours)
1.3

Lesson Objectives

SSIS Package Execution and Script Tasks

  • start the course
  • plan and design a package execution strategy
  • schedule package execution using SQL Server Agent
  • implement package execution
  • execute packages by using SQL Server Management Studio (SSMS)
  • monitor the execution using Management Studio
  • execute packages using DTEXEC and DTEXECUI
  • use PowerShell to execute SSIS packages
  • describe ETL restartability
  • determine appropriate use of script tasks
  • extend the capability of a control flow
  • perform a custom action during a control flow
  • use data flow to load data in SQL Server 2014
  • Course Number:
    md_idwm_a06_it_enus