Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Introduction to data flow tasks and transformation components
  • Managing data sources and destinations
  • Applying standard data transformations
  • Addressing data quality concerns

Control Flow in SSIS

  • Exploring control flow task mechanisms
  • Utilizing containers to govern control flow
  • Creating loops and conditional branching logic
  • Directing package execution sequences

Advanced Data Transformation Techniques

  • Leveraging advanced transformation options
  • Performing data cleansing, validation, and enrichment
  • Applying aggregation and summarization methods
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Working with Variables and Parameters

  • Overview of variables and parameter usage
  • Using variables to influence package behavior
  • Dynamically adjusting package properties

Managing SSIS Package Execution

  • Setting package execution preferences
  • Developing error handling and logging strategies
  • Managing runtime events via event handlers
  • Scheduling and automating runs using SQL Server Agent

Deploying and Managing SSIS Packages

  • Deployment models in SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring and diagnosing deployed packages

Performance Tuning and Optimization

  • Detecting and resolving performance bottlenecks
  • Applying best practices to optimize data and control flows
  • Leveraging parallelism and batch processing in SSIS

Conclusion and Future Directions

Requirements

  • Foundational knowledge of SQL and relational database principles
  • Working proficiency with SQL Server Management Studio (SSMS)

Target Audience

  • Data specialists
  • Software developers
  • Database administrators

Number of participants


Price per participant

Upcoming Courses

Related Categories