Get in Touch
 Duration 14 hours

Course Outline

Architecting Data Flows

  • An introduction to data flow tasks and core transformations
  • Interacting with various data sources and destinations
  • Applying standard data transformation processes
  • Addressing common data quality challenges

Managing Control Flow in SSIS

  • Comprehending the mechanics of control flow tasks
  • Utilizing containers to structure and manage control flow
  • Constructing loops and conditional logic structures
  • Overseeing the overall package execution sequence

Sophisticated Data Transformation Strategies

  • Leveraging advanced transformation components
  • Performing data cleansing, validation, and enrichment
  • Techniques for aggregation and data summarization
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Utilizing Variables and Parameters

  • Fundamentals of variables and parameters
  • Employing variables to dictate package behavior
  • Dynamic configuration of package properties

Overseeing SSIS Package Execution

  • Setting up package execution preferences
  • Strategies for error handling and comprehensive logging
  • Managing runtime events through event handlers
  • Automating and scheduling execution via SQL Server Agent

Deployment and Administration of SSIS Packages

  • Exploring deployment models in SQL Server 2022
  • Placing packages into the SSIS catalog
  • Monitoring performance and troubleshooting deployed packages

Optimizing Performance and Efficiency

  • Pinpointing and resolving performance bottlenecks
  • Best practices for enhancing data and control flow efficiency
  • Implementing parallelism and batch processing in SSIS

Conclusion and Future Directions

Requirements

  • A foundational grasp of SQL and relational database principles
  • Proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data professionals
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories