Learn how to extract, transform, and load data (and create ETL packages) with SQL Server Integration Services, one of the core add-on components to SQL Server.
Overview
Syllabus
Introduction
- Integrate your data with SQL Server Integration Services (SSIS)
- What you should know
- Set up the example database
- What is SSIS?
- Add SSIS to a SQL Server instance
- Connect to the SSIS catalog database
- Explore SSIS packages
- Install SQL Server Data Tools (SSDT)
- View SSIS solutions and projects
- Define control flow tasks
- Create a precedence constraint
- Create a sequence container
- Run a package
- Understanding tasks in control flow
- The Data Flow task
- The File System tasks
- Modify file attributes
- The Execute Package task
- The Send Mail task
- SQL Server tasks
- Maintenance tasks
- Project level connections
- Convert package connections
- The Excel connection manager
- Connect to flat file data sources
- Additional connection managers
- Data flow components
- Extracting data from a source
- Understand transformations
- Character Map row transformation
- Conditional Split transformation
- Rowset transformations
- Loading data to a destination
- Prevent duplicate records
- Work with variables and scope
- Add execution parameters
- Change a variable’s value
- Group tasks in looping containers
- Event handlers
- Error handling in data flows
- Deploy projects to SQL Server
- Run packages with T-SQL
- Schedule packages with SQL Server Agent
- Next steps
Taught by
Adam Wilbert
