Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimCustomer » Lineage
| Order | Task Name | Task Type | Task Description |
| 1 | Reseller Customers | OLE DB Source | OLE DB Source |
| 2 | Multicast Resellers | Multicast | Creates copies of a dataset. |
| 3 | Merge Join | Unknown | Merges data from two datasets by using a join. |
| 4 | Fill in NULLs and defaults | Derived Column | Updates column values using expressions |
| 5 | Sort by CustID, EndDate | Unknown | Sorts data. |
| 6 | Row Metadata fixup | Unknown | Executes a custom script. |
| 7 | Row Count | Row Count | Counts the rows in a dataset. |
| 8 | DimCustomer Resellers | OLE DB Destination | OLE DB Destination |