SQL Server Integration Services

SQL Server Integration Services
Map Unavailable

Date/Time
Date(s) - 27/09/2020
All Day

Categories


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.

What you’ll learn

  • Managing and administering SQL with SSIS tasks
  • Making packages dynamic with variables and parameters
  • Creating a sequence container
  • Extracting data from a source
  • Handling errors
  • Running packages with T-SQL
  • Scheduling packages with SQL Server Agent

 

Rate This Event:
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

More Events