Get in Touch
 Duration 14 hours

Course Outline

Building Data Flows

  • Introduction to data flow tasks and transformation types
  • Integration with various data sources and destinations
  • Application of standard data transformations
  • Strategies for resolving data quality challenges

SSIS Control Flow Management

  • Exploring control flow task functionalities
  • Leveraging containers to structure control flow
  • Implementing loops and conditional branching
  • Directing package execution sequences

Sophisticated Transformation Methods

  • Utilizing advanced transformation features
  • Performing data cleansing, validation, and enrichment
  • Applying aggregation and summarization strategies
  • Detailed implementation of Slowly Changing Dimensions (SCD)

Leveraging Variables and Parameters

  • Foundations of variables and parameters
  • Utilizing variables to direct package operations
  • Dynamically configuring package attributes

Overseeing SSIS Package Execution

  • Setting execution configurations
  • Implementing error management and logging protocols
  • Employing event handlers for runtime monitoring
  • Scheduling and automating tasks via SQL Server Agent

Deployment and Administration of SSIS Packages

  • Deployment models specific to SQL Server 2022
  • Publishing packages to the SSIS catalog
  • Monitoring performance and resolving issues in live packages

Optimizing Performance

  • Detecting and mitigating performance constraints
  • Best practices for streamlining data and control flows
  • Managing parallelism and batch processing within SSIS

Wrap-Up and Future Directions

Requirements

  • Fundamental grasp of SQL and relational database principles
  • 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