Get in Touch
 Duration 14 hours

Course Outline

Designing Data Flows

  • Overview of data flow tasks and transformation mechanisms
  • Integration of various data sources and destinations
  • Application of standard data transformation techniques
  • Strategies for resolving data quality issues

Control Flow in SSIS

  • Analysis of control flow task functionalities
  • Utilization of containers to structure control flow logic
  • Incorporation of loops and conditional branching
  • Management of package execution sequences

Advanced Data Transformation Techniques

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

Working with Variables and Parameters

  • Foundations of variables and parameter usage
  • Leveraging variables to regulate package behavior
  • Dynamic configuration of package properties

Managing SSIS Package Execution

  • Configuration of execution settings and options
  • Development of error handling and logging protocols
  • Utilization of event handlers for runtime event management
  • Automation and scheduling of executions via SQL Server Agent

Deploying and Managing SSIS Packages

  • Exploration of deployment models in SQL Server 2022
  • Deployment procedures to the SSIS catalog
  • Monitoring strategies and troubleshooting for live packages

Performance Tuning and Optimization

  • Identification and resolution of performance bottlenecks
  • Best practices for enhancing data and control flow efficiency
  • Application of parallelism and batch processing within SSIS

Summary and Next Steps

Requirements

  • Fundamental knowledge of SQL and relational database principles
  • Practical experience with SQL Server Management Studio (SSMS)

Intended Audience

  • Data professionals
  • Software developers
  • Database administrators

Upcoming Courses

Related Categories