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
Structuring Data Flows
- An overview of data flow tasks and associated transformations
- Managing connections with various data sources and destinations
- Applying standard data transformation techniques
- Addressing and resolving data quality concerns
Navigating SSIS Control Flow
- Comprehending the role of control flow tasks
- Leveraging containers to structure control flow logic
- Incorporating loops and conditional branching
- Regulating the overall execution sequence of packages
Advanced Transformation Strategies
- Utilizing complex transformation components
- Performing data cleansing, validation, and enrichment
- Applying aggregation and summarization methods
- Detailed implementation of Slowly Changing Dimensions (SCD)
Utilizing Variables and Parameters
- Introduction to the concept of variables and parameters
- Employing variables to dictate package behavior
- Dynamically configuring package properties
Oversight of SSIS Package Execution
- Setting package execution preferences
- Developing error handling and logging protocols
- Managing runtime events through event handlers
- Automating and scheduling tasks via SQL Server Agent
Deployment and Management of SSIS Packages
- Exploring deployment models available in SQL Server 2022
- Placing packages into the SSIS catalog
- Monitoring performance and troubleshooting live packages
Performance Optimization and Tuning
- Pinpointing and resolving performance bottlenecks
- Adopting best practices for enhancing data and control flows
- Implementing parallelism and batch processing within SSIS
Conclusion and Future Paths
Requirements
- Fundamental knowledge of SQL syntax and relational database principles
- Practical familiarity with SQL Server Management Studio (SSMS)
Target Audience
- Data professionals
- Software developers
- Database administrators
