SSIS Online Training Content
Starting with a step-step introduction to basics of server integration services followed by understanding business requirements to create SSIS packages, important tips tricks of Expressions, ADO.Net OLE DB connection managers other paramount features, this industry ready SSIS Course Curriculum is designed by SSIS Experts. By the end of training, you will feel confident that you can implement any real-time integration scenario in SSIS.
Introduction to BI Tools and life cycle
- Introduction to BI
- BI Tools
- BI Life Cycle
SSIS Transformations
- SSIS Practicals
- DB to FF FF to DB
- Aggregate Transformations
- Derived Column Transformation
- Conditional Transformation
Introduction to Control Flow
- Control Flow Tasks
- Sequence Container
- Variables
- File System Task
- FTP Task
- Send Mail Task
- Script Task
Advanced Control Flow
- Control Flow Tasks
- Webservice Task
- Execute Package Task
- Execute Process Task
- Execute SQL Task
- For each Loop Container
- Package Parameter
- Project Parameter
- Deployments
- ISPAC Files
- SSIDB Catalog
- Scheduling
Data Flow Transformations
- String Datatypes in SQL Server
- Data Conversion Transformation
- Set Operators in SQL Server
- Merge Transformation
- Union All Transformation
- Multicast Transformation
Advanced Data Flow
- Merge Join Transformation
- Lookup Transformation
- OLEDB Transformation
