Building Your First SSIS 2016 Package
This course will help you learn to develop SSIS packages to be able to loop through sources, move data, and process tasks with automation.
What you'll learn
The foundation for getting started in SQL Server Integration Services is a package. This file or object is the container of the data transformations built for moving data from a source to a destination. In this course, Building Your First SSIS 2016 Package, you’ll gain the ability to navigate the important areas for using SQL Server Data Tools to design, manage, and deploy SSIS packages. First, you’ll explore the development tool for managing SSIS packages in projects. Next, you'll discover the data flow area will be used to move data from source to destination in the main canvas or control flow. Many components or tasks will be used in a data flow that are common for extracting, transforming, and loading (ETL) data. Finally, you'll see the management of a deployment and execution of a package is demonstrated step by step. When you’re finished with this course, you’ll have the skills and knowledge of developing SSIS packages needed to loop through sources, move data, and process tasks with automation.
Table of contents
- Version Check 0m
- Planning Data Integration Introduction 5m
- Demo: Files Needed for This Course 4m
- Creating a Project and Package 2m
- Demo: Creating a Project and Package 4m
- Developing the Flow of Data Integration 2m
- Demo: Developing the Flow of Data Integration 4m
- Summary: Planning Data Integration 1m
- Introduction: Managing SSIS Projects 1m
- Managing SSIS Projects 1m
- Demo: Connections and Variables in a Package 2m
- Sharing Connections Between Packages 1m
- Demo: Sharing Connections Between Packages 2m
- Using Project Parameters in Expressions 1m
- Demo: Using Project Parameters in Expressions 2m
- Creating the Catalog 1m
- Demo: Creating the Catalog 2m
- Deploying to Catalog 1m
- Demo: Deploying to Catalog 4m
- Summary: Managing SSIS Projects 1m
- Introduction: Extract and Transform Data 1m
- Implementing a Data Flow 2m
- Connections and Sources 1m
- Demo: Data Flow, Connections, and Sources 6m
- Transforming Data in a Data Flow 3m
- Demo: Transforming Data in a Data Flow 3m
- Checking for Existing Data 1m
- Demo: Lookup, Conditional Split, and OLEDB Command 6m
- Using a Data Viewer 1m
- Demo: Using a Data Viewer 2m
- Summary: Extract and Transform 1m
- Introduction: Loading Data 1m
- Implementing Control Flow 3m
- Demo: Implementing Control Flow 6m
- Loops and Containers 1m
- Demo: Loops and Containers 7m
- Executing T-SQL or Stored Procedures 2m
- Demo: Executing T-SQL or Stored Procedures 2m
- Precedence Constraints 1m
- Demo: Precedence Constraints 2m
- Summary: Loading Data 1m
- Introduction: Configure and Deploy SSIS Packages 1m
- Deploying SSIS Solutions 2m
- Demo: Deploying SSIS Solutions 4m
- Environments and Mapping 2m
- Demo: Environments and Mapping 2m
- Executing Package with an Environment 2m
- Demo: Executing Package with an Environment 3m
- Summary: Configure and Deploy SSIS Packages 1m
About the author
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.