SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database, it is used for performing a wide range of data integration tasks. This module provides detailed knowledge of data migration techniques, how to work with dataflow transformations, SSIS packages, event handling, implement checklists, deployment procedures, and much more through best practices.
- Introduction to SSIS Packages
- Introduction of (SSDT) and Explanation of All toolboxes, Solution Explorer, Package variables
- Import and Export Wizard, Control Flow and Dataflow tasks
- Control Flow tasks like Execute SQL Task, BULK insert tasks, File System tasks, The FTP Task
- Dataflow tasks and transformations introduction
- Data sources, Data transformations, Copy column Transformation, Derived Column transformation, Conditional Split and Aggregate Transformation, Sort
- Transformation and Data Viewers.
- Slowly Changing Dimension (SCD) Concepts and its Transformations.
- How to implement Check points.
- SSIS Package Deployment and Package Management like how to schedule package,
- DTUtil and DTExec command.