Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Constructing Data Flows
- An overview of data flow tasks and their associated transformations.
- Integration of various data sources and output destinations.
- Application of standard data transformation techniques.
- Strategies for addressing data quality concerns.
Managing Control Flow in SSIS
- In-depth understanding of control flow tasks.
- Utilizing containers to orchestrate control flow logic.
- Implementation of loops and conditional branching.
- Supervising the overall execution flow of the package.
Sophisticated Data Transformation Methods
- Leveraging advanced transformation tools.
- Processes for data cleansing, validation, and enrichment.
- Techniques for data aggregation and summarization.
- Detailed implementation of Slowly Changing Dimensions (SCD).
Utilizing Variables and Parameters
- Fundamentals of SSIS variables and parameters.
- Employing variables to modulate package behavior dynamically.
- Configuring package properties for dynamic adjustments.
Supervising SSIS Package Execution
- Setting up execution options for optimal performance.
- Implementing comprehensive error handling and logging protocols.
- Managing runtime events through event handlers.
- Scheduling and automating package runs via SQL Server Agent.
Deployment and Package Administration
- Exploring deployment models specific to SQL Server 2022.
- Publishing packages to the SSIS catalog.
- Monitoring health and troubleshooting deployed solutions.
Performance Enhancement and Optimization
- Identifying and resolving performance bottlenecks.
- Applying best practices to streamline data and control flows.
- Leveraging parallelism and batch processing within SSIS.
Wrap-up and Future Steps
Requirements
- A fundamental grasp of SQL syntax and relational database principles.
- Working familiarity with SQL Server Management Studio (SSMS).
Target Audience
- Data specialists
- Software developers
- Database administrators