SQL Server Integration Services [SSIS]
1. Introduction to SQL Server Integration Services (SSIS)
SSIS Package Architecture Overview
Development and Management Tools
Project templates
The package designer
The Toolbox, Solution Explorer
Properties window, Variables window
SSIS menu
2. Introduction to Control Flow
Control Flow Overview (Tasks, Containers):
Execute SQL Task, Bulk Insert Task, File System Task
Script Task, Precedence Constraints, Send Mail Task
Execute Process Task, Execute Package Task
Containers : For Loop, ForEach, Sequence Container
3. Introduction to Data Flow
Data Flow Overview
Data Sources, Data Destinations, Data Transformations
Copy Column, Derived Column Transformations
Data Conversion Transformation
Multicast, Conditional Split Transformations
Aggregate, Audit, Pivot Transformations
Mege, Merge Join, UnionAll Transformations
Sort Transformation
Slowly Changing Dimension (SCD)
Lookup, Cache Transformations
Fuzzy Lookup, Fuzzy Grouping Transformations
Data Viewers
Parallel Processing (MaxConcurrentExecutables, EngineThreads)
Containers : For Loop, ForEach, Sequence Container
3. Introduction to Data Flow
Data Flow Overview
Data Sources, Data Destinations, Data Transformations
Copy Column, Derived Column Transformations
Data Conversion Transformation
Multicast, Conditional Split Transformations
Aggregate, Audit, Pivot Transformations
Mege, Merge Join, UnionAll Transformations
Sort Transformation
Slowly Changing Dimension (SCD)
Lookup, Cache Transformations
Fuzzy Lookup, Fuzzy Grouping Transformations
Data Viewers
Parallel Processing (MaxConcurrentExecutables, EngineThreads)
4. Variables and Configurations
Variables Overview and Scope
SSIS system variables
Using variables in control flow and Data Flow
Using variables to pass information between packages
Property expressions
Package Configuration Overview
Package Configuration options
5. Debugging , Error Handling and Logging
SSIS debugging overview
Breakpoints in SSIS
SSIS debugging windows
Enabling and Configuring Package Logging
Configure Error Output (Redirect Rows, Ignore Failures, Fail Component)
Event Handlers (OnError, OnPreExecute, OnPostExecute, OnPreValidate, OnPostValidate, OnTaskFailed, OnProgress)
Configure Error Output (Redirect Rows, Ignore Failures, Fail Component)
Event Handlers (OnError, OnPreExecute, OnPostExecute, OnPreValidate, OnPostValidate, OnTaskFailed, OnProgress)
6. Extending SSIS through Custom Code
Introduction to SSIS scripting
The SSIS script editor
Script in Control flow: The Script Task
Script in Data flow: The Script Component
Introduction to SSIS component development
CheckPoints
Transaction Options (Required, Supported, Not Supported)
FailPackageOnFailure
MaximumErrorCount
Propagate
MaximumErrorCount
Propagate
8. SSIS Package Deployment
Package Configurations and deployment
The deployment utility
Different types of Deployments
Package security
Executing packages – DTExec and DTExecUI
9. SSIS Package Management
Managing packages with DTUtil
Managing packages with SQL Server Management Studio
Scheduling packages with SQL Server Agent
10. SSIS for DBAs: Using SQL Server Management Studio
The Import and Export Wizard
Importing and Exporting Data
Working with Packages
Database Maintenance Plans
Creating Database Maintenance Plans using SSMS
Scheduling and Executing Plans
Resume Preparation ***********
Interview Tips, Questions and Guidance **********
