- Course
- Cloud
- Data
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.
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.
Table of contents
- Overview | 3m 55s
- Workflow: Message Queue Task | 6m 32s
- Workflow: Execute Package Task | 2m 59s
- Workflow: Execute Process Task | 3m 14s
- Data Preparation: File System Task | 3m 17s
- Data Preparation: XML Task | 4m 14s
- Data Preparation: Data Profiling Task | 3m 8s
- Data Preparation: FTP Task | 2m 53s
- SQL Server Tasks | 2m 24s
- SQL Server: Bulk Insert Task | 4m 29s
- Database Maintenance Tasks | 2m
- Summary | 1m 21s