SSIS: SQL Server Integration Services Course Content
Introduction to SQL Server Integration Services
- Product History
- SSIS Package Architecture Overview
- Development and Management Tools
- Deploying and Managing SSIS Packages
- Source Control for SSIS Packages
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 · Examining Database Maintenance Plan Packages
Business Intelligence Development Studio
- Launching BIDS
- Project templates
- The package designer
- The Toolbox
- Solution Explorer
- The Properties window
- The Variables window · The SSIS menu
Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
- The FTP Task
- The Send Mail Task
Advanced Control Flow
- Containers – grouping and looping
- The Web Service Task
- The WMI tasks
- The Analysis Services tasks
- The Execute Process Task · The Execute Package Task
Introduction to Data Flow
- Data Flow Overview
- Data Sources
- Data Destinations
- Data Transformations
- The Copy Column Transformation
- The Derived Column Transformation
- The Data Conversion Transformation
- The Conditional Split Transformation
- The Aggregate Transformation
- The Sort Transformation
- Data Viewers
Variables and Configurations
- Variables Overview
- Variable scope
- SSIS system variables
- Using variables in control flow
- Using variables in data flow
- Using variables to pass information between packages
- Property expressions
- Configuration Overview
- Configuration options
Debugging, Error Handling and Logging
- SSIS debugging overview
- Breakpoints in SSIS
- SSIS debugging windows
- Control Flow: The on Error event handler
- Data Flow: Error data flow
- Configuring Package Logging · Built-in log providers
Advanced Data Flow
- Revisiting data sources and destinations
- The Lookup Transformation
- Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
- The Multicast Transformation
- The Merge and Merge Join Transformations
- The Data Mining Query Transformation
- The Data Mining Model Training Destination
- The Slowly Changing Dimension Transformation
Extending SSIS through Custom Code
- Introduction to SSIS scripting
- The SSIS script editor
- The SSIS object model
- Script in Control flow: The Script Task
- Script in Data flow: The Script Component
- Introduction to SSIS component development
SSIS Package Deployment
- Configurations and deployment
- The deployment utility
- Deployment options
- Deployment security
- Executing packages – DTExec and DTExecUI
SSIS Package Management
- The SSIS Service
- Managing packages with DTUtil
- Managing packages with SQL Server Management Studio
- Scheduling packages with SQL Server Agent
SSIS 2012 new features
- CDC (Change data capture) control Flow & Data flow task
- SSIS Catalog Reports (Dashboard)
- Package upgrades from legacy to SSIS 2012
