Course Outline

Designing Data Flows for Government

  • Overview of data flow tasks and transformations for government
  • Working with data sources and destinations for government
  • Implementing common data transformations for government
  • Handling data quality issues for government

Control Flow in SSIS for Government

  • Understanding control flow tasks for government
  • Using containers to manage control flow for government
  • Implementing loops and conditional logic for government
  • Managing package execution flow for government

Advanced Data Transformation Techniques for Government

  • Using advanced transformations for government
  • Data cleansing, validation, and enrichment for government
  • Aggregation and summarization techniques for government
  • Implementing Slowly Changing Dimensions (SCD) in detail for government

Working with Variables and Parameters for Government

  • Introduction to variables and parameters for government
  • Using variables to control package behavior for government
  • Dynamic configuration of package properties for government

Managing SSIS Package Execution for Government

  • Configuring package execution options for government
  • Error handling and logging strategies for government
  • Using event handlers to manage runtime events for government
  • Scheduling and automating execution with SQL Server Agent for government

Deploying and Managing SSIS Packages for Government

  • Deployment models in SQL Server 2022 for government
  • Deploying packages to the SSIS catalog for government
  • Monitoring and troubleshooting deployed packages for government

Performance Tuning and Optimization for Government

  • Identifying and addressing performance bottlenecks for government
  • Best practices for optimizing data flows and control flows for government
  • Parallelism and batch processing in SSIS for government

Summary and Next Steps for Government

Requirements

  • Basic understanding of SQL and relational database concepts
  • Familiarity with SQL Server Management Studio (SSMS)

Audience for Government

  • Data professionals
  • Developers
  • Database administrators
 14 Hours

Number of participants


Price per participant

Runs with a minimum of 4 + people. For 1-to-1 or private group training, request a quote.

Testimonials (1)

The thorough / hands-on knowledge the trainer has.

Pieter Peirs
Course - Introduction to SQL Server 2012 Integration Services (SSIS)

Upcoming Courses

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

2026-01-29 09:30
14 hours
Flowood, MS – Regus at Market Street
$ 2703 (Online)
$ 2703 (Classroom)

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

2026-02-12 09:30
14 hours
Reno, NV – Regus - Downtown
$ 2703 (Online)
$ 2703 (Classroom)

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

2026-02-26 09:30
14 hours
Nashua, NH – Regus at One Tara Boulevard
$ 2703 (Online)
$ 2703 (Classroom)

Related Courses

Introduction to SQL Server 2012 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in US Empire (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services for government.

By the end of this training, participants will be able to:

  • Understand the principles of ETL and the role of SSIS in public sector workflows.
  • Create, deploy, and manage SSIS packages for government applications.
  • Design and implement Control Flow to define the flow of tasks in a package, ensuring alignment with governance requirements.
  • Implement Workflow and set up constraints for effective task execution in a government context.
  • Construct Data Flows to extract, transform, and load data, supporting efficient data management for government.
  • Work with Variables and Containers to enhance package flexibility, aligning with public sector needs.
  • Manage Transactions to ensure data consistency and integrity in government systems.
  • Implement effective error handling and debugging techniques to maintain reliability for government operations.
  • Set up Logging for tracking and monitoring to support accountability in government processes.
  • Handle Slowly Changing Dimensions for managing changing data, ensuring accurate and up-to-date information for government use.
  • Deploy a Package for production use, adhering to government deployment standards.
  • Implement Security measures to protect sensitive data within government systems.
  • Utilize Scripting to extend SSIS functionality, enhancing capabilities for government applications.
  • Apply Best Practices for efficient and maintainable SSIS solutions, ensuring long-term sustainability for government projects.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in US Empire (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks for government.

By the end of this training, participants will be able to:

  • Understand the architecture and components of SSIS within a public sector context.
  • Design and implement ETL processes using SSIS to support governmental workflows and data governance.
  • Utilize SSIS tools to develop, deploy, and manage data integration solutions that align with government standards and requirements.
  • Troubleshoot and optimize SSIS packages for performance and reliability in a government environment.
Read more...

Related Categories

SSIS
SSIS