- Introduction
- Install SQL 2016 if you have not
- Down Load and Install SQL 2016
- Correction
- Download and Install Data Tools for SSRS
- Download and install Sample database
- What is SSIS
- SQL to SQL Export Transformation
- SQL to Excel Transformation
- Control Flow and Data Flow
- Create a SSIS Package
- Truncate a Table
- SQL to Flat File
- FTP Site Transformation
- Conditional Split Transformation
- Truncate tables for conditional split
- Derived Column Task Transformation
- Character Map Transformation
- Merge Transformation
- Union All Transformation
- Multicast Transformation
- Aggregates Transformation
- Term Extraction Transformation
- Audit Transformation
- Data Conversion Transformation
- Backup Task Transformation
- For Each Container Transformation
- For Each Container Task Transformation
- For Each Container Job
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
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.
Students also bought
Información sobre el Instructor

- 4.43 Calificación
- 105277 Estudiantes
- 25 Cursos
Raphael Asghar
Production SQL Database Administrator
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.