Building More Efficient ETL Pipelines with Task Factory


Building ETL pipelines in SQL Server Integration Services (SSIS) can be difficult and time-consuming. You need to make sure your packages run as efficiently as possible, with the least amount of development effort required.

In this webinar, we’ll examine some common ETL design patterns and how you can address them efficiently both in native SSIS and using SentryOne Task Factory components.

We'll show you how to handle:

  • A slowly changing dimension
  • Insert and Update into the same target table
  • Key lookups when you have complex join conditions

You will learn how to make your SSIS packages run faster when faced with these scenarios, and how to use Task Factory to handle these scenarios with minimal development cost.

Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

John Welch

John Welch

Senior Vice President of Engineering

John (@john_welch) leads the development of a suite of data and BI products that make developing, testing, managing, and documenting data solutions faster and more efficient. John has been working with data, business intelligence, and data warehousing technologies since 2001. He was awarded as a Microsoft Most Valued Professional (MVP) 2009 - 2016 due to his commitment to sharing his knowledge with the IT community, and is an SSAS Maestro. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), SQL Bits, and others. He has also contributed to multiple books on SQL Server and business intelligence.

C.J. Lowery

C.J. Lowery

Technical Specialist

C.J. Lowery is a Technical Specialist at SentryOne, working with SQL Server databases and SQL Server Integration Services. He supports customers through the setup and configuration of SentryOne software, writes articles for the SentryOne Product Knowledge Base, tests software builds, and assists with content creation.

Companies with the highest demands for database performance choose SentryOne