SQL Server Integration Services

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.

Introduction

• Integrate your data with SQL Server Integration Services (SSIS)
• What you should know
• Set up the example database

1. Get Started with Integration Services

• What is SSIS?
• Add SSIS to a SQL Server instance
• Connect to the SSIS catalog database
• Explore SSIS packages

2. SSIS Designer

• 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

3. Control Flow Tasks

• 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

4. Data Sources and Connections

• Project level connections
• Convert package connections
• The Excel connection manager
• Connect to flat file data sources
• Additional connection managers

5. The Data Flow Task and Transformations

• 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

6. Controlling Package Execution

• 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

7. Deploy and Run SSIS Projects

• Deploy projects to SQL Server
• Run packages with T-SQL
• Schedule packages with SQL Server Agent

Conclusion

• Next steps