This screencast introduces the concept of Data Flow within
SQL Server Integration Services (SSIS) including the use of Merge Join and Derived columns.
This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners. This training event takes the student through the Microsoft BI Platform giving a BI Developer the introduction and basic comfort needed to tackle a BI project using Microsoft technology.
If you missed the first screencast in this series I highly recommend that you watch it first as it provides a great overview of Microsoft BI technology. Additional screencasts will be published under the "SQL+Server" so subscribe to it now!