- Course
- Data
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 | 1m 54s
- Why Use Integration Services? | 1m 57s
- Environment Setup | 2m 29s
- Reviewing the Environment Setup | 6m 37s
- Reviewing the Hello World Package | 6m 49s
- Package Development Options | 1m 33s
- Using the SSIS Import and Export Wizard: Management Studio | 3m 33s
- Using the SSIS Import and Export Wizard: Visual Studio | 4m 44s
- Creating a Package in Visual Studio | 2m 24s
- Project Interface | 6m 42s
- Course Roadmap | 1m 45s
- Globomantics Requirements | 1m 57s
- Summary | 1m 37s