Description

Build, deploy and maintain SSIS packages that extract, transform and load data, using SQL Server 2025 Integration Services and Visual Studio 2022.

Price$3,000Per person

Time30 course hoursOn-demand video and labs, plus 3 hours of coaching

DeliveryOn-demand asynchronous trainingWith online support and 3 hours of coaching

CredentialCertificate of completionFrom We Can Code IT

About this course

This course teaches you to build and run SQL Server Integration Services (SSIS) packages that move and reshape data between systems. You learn on the current version, SQL Server 2025 Integration Services, with Visual Studio 2022. You design control flow and data flow, apply transformations, make packages dynamic with parameters and loops, handle errors and logging, and deploy and schedule packages from the SSIS Catalog, then finish with a complete extract, transform and load project.

Who it is for

This course is for database professionals, business intelligence developers and data engineers who move data between systems. It also suits SQL developers who have been asked to take over existing SSIS packages.

Prerequisites

Working Transact-SQL knowledge and familiarity with relational databases

Basic Windows skills

SQL Server Agent experience is helpful but not required

Requirements

Requires a Windows PC

64-bit Windows; SQL Server Management Studio 21 and SSIS Projects 2022 are 64-bit only

Visual Studio 2022 with the SQL Server Integration Services Projects 2022 extension

SQL Server 2025 Developer edition with Integration Services, which Microsoft provides free for development and training

SQL Server Management Studio 21 or later

What you will be able to do

You will be able to create an SSIS project in Visual Studio and build control flow with tasks, precedence constraints and connection managers.
You will be able to load data from flat file, Excel and SQL Server sources into SQL Server destinations.
You will be able to clean and reshape data with Derived Column, Data Conversion, Lookup, Conditional Split and Aggregate transformations.
You will be able to make packages dynamic with parameters, variables, expressions and Foreach Loop containers.
You will be able to troubleshoot packages with data viewers, logging, error outputs and event handlers.
You will be able to deploy packages to the SSIS Catalog, configure environments and schedule them with SQL Server Agent.

Syllabus

SSIS overview and your first project 3 hours

What SSIS does, Import and Export Wizard, Solutions and projects in Visual Studio, Changes in SSIS for SQL Server 2025.

Lab: You set up Visual Studio with the SSIS Projects extension, move a table with the Import and Export Wizard and then rebuild the same load as a package.

Control flow 4 hours

Tasks, Precedence constraints, Connection managers, Execute SQL task, File System task.

Lab: You build a package that archives incoming files, truncates a staging table and runs only the next step when the previous one succeeds.

Data flow sources and destinations 3.5 hours

Flat file sources, Excel sources, SQL Server sources and destinations, ADO.NET connection manager.

Lab: You load customer data from a CSV file and an Excel workbook into SQL Server staging tables.

Data flow transformations 5 hours

Derived Column, Data Conversion, Lookup, Conditional Split, Aggregate, Handling bad rows.

Lab: You clean and standardize the staged customer data, match it to existing records with Lookup and send rows that fail checks to a reject table.

Dynamic packages and containers 4 hours

Parameters, Variables, Expressions, Sequence containers, Foreach Loop containers.

Lab: You change the load so it processes every file in a folder and takes its folder path and server name from parameters.

Troubleshooting and package reliability 3.5 hours

Data viewers, Logging, Error outputs, Event handlers.

Lab: You find and fix planted errors in a broken package and add logging and an event handler that records each failure.

Deploying and scheduling 4 hours

Deploying to the SSIS Catalog, Environments, Running packages from the Catalog, Scheduling with SQL Server Agent.

Lab: You deploy your project to the SSIS Catalog, set up test and production environments and schedule the load with a SQL Server Agent job.

End-to-end ETL project 3 hours

Requirements to package design, Extract, transform and load, Error handling and logging, Deployment and scheduling.

Lab: You build, deploy and schedule a complete package from a short specification that loads sales files into a reporting table and handles bad rows.

Coaching sessions 3 hours

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 3 hours of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

SQL Server Integration Services

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

TechCred's maximum is $1,000 per person, per credential, toward this price.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

Name

Work email

Organization

Number of employees

When would training start?

Delivery

Send us a written quote to include with our TechCred application

Anything else we should know?

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.