- Course
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.
- Course
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.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Cloud
- Data
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.
Integration Services Fundamentals Part 2
-
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