Sql Server Administration Sql Server Integration Services

Learn how to create SSIS packages that allow migration of data from source to destination

Last updated 2022-01-10 | 4.5

- At the end of this course
- the student will be able to design
- configure
- manage and deploy SSIS packages that migrate data from source to destination using many platforms

What you'll learn

At the end of this course

the student will be able to design

configure

manage and deploy SSIS packages that migrate data from source to destination using many platforms

* Requirements

* The pre requisite courses SQL Administration Part 1
* 2
* 3
* Learn T-SQL and SSRS are highly recommended. All software and SQL scripts and documents will be provided via email zip file

Description

This course is designed for those who want to learn how to create SQL SSIS packages that migrate data from various heterogeneous sources to a central point and shows the student how to extract, transform and load data to various destinations. The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. Those that are not familiar with SQL Server Administration should not take this course. The course covers data transformation tasks such as, data conversion, term extraction, migration to flat files, various databases sources and destinations, FTP site tasks, and foreach look container that allows the SSIS package to dump multiple files from source to destination. Those that finish this course will have the necessary skills that recruiters are looking for to fill SQL Server Administration jobs.

Who this course is for:

This course is designed for those who want to learn how to create SQL SSIS packages that migrate data from various heterogeneous sources to a central point and shows the student how to extract, transform and load data to various destinations. The pre requisite courses SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended. Those that are not familiar with SQL Server Administration should not take this course.