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.
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.
Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections
conferences, and various SQL Saturday and Microsoft-related events
Course Overview Hi, everyone. My name is Stacia Varga, and welcome to my course, Designing SSIS Integration Solutions. I'm a consultant and an author at Data Inspirations, and I've been working with SSIS since its initial release in 2005, and I've been designing and implementing data integration solutions for much longer than that. SSIS is a great tool that you can use to build data integration solutions, and it's especially good for data warehousing projects. Although it's pretty easy to build out SSIS packages, it's important to put some thought into what you want to build so that you have consistency across multiple packages which makes it easier to maintain and troubleshoot over time. In this course, I'm going to show you how to think about developing requirements for a data integration project and show you design patterns for developing SSIS to support a data warehouse. Some of the major topics that we'll cover include understanding where the SSIS design process fits into a project, SSIS concepts and terminology, and characteristics of preparing solid ETL requirements and design documents. By the end of this course, you'll be able to use this information to design your own SSIS data integration solutions, whether it's for a data warehouse or some other type of data. Before beginning this course, you should be familiar with relation database concepts and know how to write SQL statements. And then once you complete this course, you should feel comfortable diving into other SSIS courses. So come on, join me on this journey of designing SSIS integration solutions, at Pluralsight.