SSIS Package Execution and Script Tasks

SSIS Package Execution and Script Tasks

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

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

Expertise Level
Intermediate