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.
Learning Objectives
SSIS Package Execution
- 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
Script Tasks in SSIS
- determine appropriate use of script tasks
- extend the capability of a control flow
- perform a custom action during a control flow
Practice: Implementing Data Flow
- use data flow to load data in SQL Server 2014