Integration Services Fundamentals Part 1
This course is for business intelligence developers and database professionals responsible for moving, manipulating, and integrating data. You'll delve into a big picture view of Integration Services to better understand what it can do for you.
What you'll learn
Integration Services is a powerful tool for data wrangling, whether you need to do something simple like move data from point a to point b, or perform more complex operations to reshape and refine your data. In this course, Integration Services Fundamentals Part 1, you'll learn how to develop Integration Services packages with an emphasis on the development of processes that support data warehousing. First, you'll explore the overall process of package development and the concepts related to control flow and data flow. Next, you'll discover the ability to customize Integration Services behavior with variables and simple expressions. Finally, you'll learn how to automate the execution of packages. By the end of this course, you’ll have the necessary knowledge of Integration Services needed to start building simple packages on your own.
Table of contents
- Overview 2m
- Why Use Integration Services? 2m
- Environment Setup 2m
- Reviewing the Environment Setup 7m
- Reviewing the Hello World Package 7m
- Package Development Options 2m
- Using the SSIS Import and Export Wizard: Management Studio 4m
- Using the SSIS Import and Export Wizard: Visual Studio 5m
- Creating a Package in Visual Studio 2m
- Project Interface 7m
- Course Roadmap 2m
- Globomantics Requirements 2m
- Summary 2m
- Overview 3m
- Expressions 3m
- Concatenating Values 4m
- Variables 3m
- Using Variables with Execute SQL and for Each Loop 4m
- Using Expressions to Set Task Properties 5m
- Using an Expression with a Connection Manager 3m
- Constructing a SQL Statement with an Expression 3m
- Using an Expression with a Precedence Constraint 2m
- Using Expressions in a for Loop, Variable, and Connection Manager 4m
- Parameters 4m
- Summary 2m
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.