What you'll learn

If you need to move, manipulate, and integrate data across multiple platforms, you need to know how to use Integration Services effectively. In this course, Integration Services Fundamentals Part 2, you continue building on concepts introduced in the Integration Services Fundamentals Part 1 course and you’ll gain the ability to build packages that achieve your data integration goals. First, you’ll explore the control flow tasks and data flow components not covered in Part 1. Next, you’ll discover how to use scripting to perform operations not covered by the built-in components. Finally, you’ll learn how to debug packages and handle potential package execution problems. When you’re finished with this course, you’ll have the skills and knowledge of Integration Services needed to develop, manage, and maintain packages.