fbpx
0(0)

Extracting and Transforming Data in SSIS

  • by Handson
  • Course level: All Levels

Description

Data engineering is in the backbone of advanced analytics, business intelligence, and machine learning activities, and is also one of the most exciting and rewarding professions in the IT industry today.

SSIS is the main SQL Server tool for achieving ETL (Extract, Transform, and Load) goals, whether you are:

  • Building a data warehouse
  • Ransforming unstructured or semi-structured files into valuable insights, or
  • Loading massive amounts of information for data sciences operations

In this SSIS tutorial, Extracting and Transforming Data in SSIS, you’ll learn how to use SSIS to create and execute ETL Packages.

First, you’ll discover how to use conditional logic and loops to control your data flow.

Next, you’ll delve into integrating data from sources other than databases. Then, you’ll explore additional processes, scripts, and packages to expand your ETL capabilities beyond SSIS.

Finally, you’ll learn how to transform data using Data Flow operations, and pipe data by Split, Merge, and Union operations.

By the end of this tutorial, you’ll be able to use SSIS to execute fundamental ETL processes.

pluralsight
Free

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Handson School of Data Science will use the information you provide on this form to be in touch with you and to provide updates and marketing.

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Handson School of Data Science will use the information you provide on this form to be in touch with you and to provide updates and marketing.