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; while at the same time it will show the student how to extract, transform and load data to various destinations. The course will cover the following:
• Prerequisite courses: SQL Administration Part 1, 2, 3, Learn T-SQL and SSRS are highly recommended
• Creating SSIS packaged from scratch
• Executing Data transformation tasks such as, data conversion, term extraction, for each look container
• Connecting to various databases sources and destinations
• Examples of movement of data from heterogeneous environments and much more