Integration Services Fundamentals Part 2

This course is for business intelligence developers and database professionals responsible for moving, manipulating, and integrating data and assumes completion of the Integration Services Fundamentals Part 1 course.

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.

• Course Overview 1min
• Control Flow Tasks 40mins
• Data Flow Sources and Destinations 28mins
• Data Flow Transformations 52mins
• Integration Services for Business Intelligence Solutions 29mins
• Scripts 25mins
• Debugging SSIS Packages 24mins
• Package Reliability 33mins