Get in Touch
 Duration 14 hours

Course Outline

Architecting Data Flows

  • Exploring data flow tasks and transformation capabilities
  • Integrating various data sources and destinations
  • Applying standard data transformation patterns
  • Strategies for addressing data quality challenges

Managing Control Flow in SSIS

  • Comprehending the role of control flow tasks
  • Utilizing containers to structure control flow
  • Building loops and implementing conditional logic
  • Orchestrating the overall package execution sequence

Advanced Transformation Methods

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

Utilizing Variables and Parameters

  • Foundations of variables and parameters
  • Using variables to dynamically influence package behavior
  • Dynamic adjustment of package properties

Executing SSIS Packages

  • Setting package execution preferences
  • Implementing error handling and logging frameworks
  • Managing runtime events through event handlers
  • Automating scheduled execution via SQL Server Agent

Deployment and Package Management

  • Reviewing deployment models in SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring performance and troubleshooting live packages

Performance Optimization

  • Detecting and resolving performance bottlenecks
  • Best practices for refining data and control flows
  • Optimizing parallelism and batch processing in SSIS

Conclusion and Path Forward

Requirements

  • Foundational knowledge 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