Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimPromotion » Lineage
| Order | Task Name | Task Type | Task Description |
| 1 | Source from SpecialOffer | OLE DB Source | OLE DB Source |
| 2 | Multicast | Multicast | Creates copies of a dataset. |
| 3 | Fix NULL | Derived Column | Updates column values using expressions |
| 4 | Row Metadata | Derived Column | Updates column values using expressions |
| 5 | Row Count | Row Count | Counts the rows in a dataset. |
| 6 | OLE DB Destination | OLE DB Destination | OLE DB Destination |