Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server Integration Services

via LinkedIn Learning

Overview

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.

SQL Server Integration Services (SSIS) is one of the core add-on components to SQL Server. With SSIS, professionals can create automated workflows that streamline the process of consolidating data from a wide variety of sources. Through a process called ETL—extract, transform, and load—you can ingest and move data between systems such as other databases, flat data files, and even online repositories. In this course, Adam Wilbert helps you get up and running with SSIS. Adam shows how to work with different control flow tasks, data sources, connections, and transformations. Plus, see how to add variables to control package execution, run packages with T-SQL, and more.

Syllabus

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

Taught by

Adam Wilbert

Related Courses

Reviews

Start your review of SQL Server Integration Services

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free