Learn SSIS concepts with simple examples

SSIS Concepts

What you’ll learn:
Learn how to create SSIS packages
Learn how to use transformations in Control flow and Data flow tasks
Learn how to extract, transform and load data from and to various sources
Learn how to use synchronous and asynchronous transformations
Learn the development concepts in SSIS

Requirements
Install SQL Server 2019, Install Visual Studio and SQL Server Data tools

Description
SSIS is an ETL tool that is being widely used in software industry for extraction, transformation and loading of data. It helps in data integration and useful in data warehousing applications. This course is designed for anyone who wants to build a career in SSIS and for those who want to improve their skills in SSIS. It covers all the important topics of SSIS. The concepts of SSIS are explained with simple examples. This helps in quickly learning the concepts of the subject.

This course has about 8 hours of valued learning comprising 85 lectures incorporated under 9 sections. In this course you will learn how to extract data from different sources like excel, sql server and flat file. You will learn how to transform the extracted data according to business needs using control flow tasks, synchronous data flow tasks, asynchronous data flow tasks and other tasks. You will also learn various development concepts in the process. You will learn how to send the final information obtained by extraction and transformation to various locations. Simple examples are used for easy understanding. Queries and files used are given as resource for each lesson

This course helps in giving a solid foundation for you in SSIS.

Who this course is for
This course is designed for anyone who wants to build a career in SSIS and for those who want to improve their skills in SSIS