Simple play icon Course

Designing SSIS Integration Solutions

by Stacia Misner Varga

SQL Server Integration Services (SSIS) is a flexible feature in SQL Server that supports scalable, high-performance extract, transform, and load (ETL) tasks. This course will teach you best practices for the design of an SSIS ETL solution.

What you'll learn

Business intelligence solutions often require data sources to be transformed into dimensional model structures that are better suited for reporting and analysis than operational data structures. After the design of a dimensional model is complete, the next step is to design extract, transform, and load (ETL) processes. In this course, Designing SSIS Integration Solutions, you’ll learn how to analyze, organize, and document requirements for an ETL solution to be implemented in SSIS. First, you’ll explore tools and techniques for translating business requirements into ETL requirements and ensure best practices are applied. Next, you’ll discover how to design the data integration workflow for common ETL tasks in SSIS. Finally, you’ll learn about other best practices to incorporate into your SSIS packages for optimal performance and security. When you’re finished with this course, you’ll have the skills and knowledge of SSIS design needed to successfully plan for the development of your own ETL solutions.

Table of contents

About the author

Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

Ready to upskill? Get started