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 4m
- Workflow: Message Queue Task 7m
- Workflow: Execute Package Task 3m
- Workflow: Execute Process Task 3m
- Data Preparation: File System Task 3m
- Data Preparation: XML Task 4m
- Data Preparation: Data Profiling Task 3m
- Data Preparation: FTP Task 3m
- SQL Server Tasks 2m
- SQL Server: Bulk Insert Task 4m
- Database Maintenance Tasks 2m
- Summary 1m
- Overview 2m
- Row Transformations 3m
- Using the Copy Column, Character Map, and Export Column Transformations 6m
- Using the Import Column Transformation 2m
- Rowset Transformations 2m
- Converting Multiple Rows to a Crosstab 5m
- Flattening a Crosstab to Multiple Rows 3m
- Sampling Data 4m
- Split and Join Transformations 2m
- Using the Multicast and Union All Transformations 3m
- Consolidating Two Datasets with Merge 4m
- Consolidating Two Datasets with Merge Join 4m
- Using the Cache Transformation 5m
- Auditing Transformations 4m
- Summary 1m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.