Date Dims

Date Dims creates a new derived column called INTERACTIONRESPONSEDATEDIMID using the expression:

ISNULL(INTERACTIONRESPONSEDATE) ? 0 : YEAR(INTERACTIONRESPONSEDATE) * 10000 + MONTH(INTERACTIONRESPONSEDATE) * 100 + DAY(INTERACTIONRESPONSEDATE)

When you create new packages that use date dimensions, you should adjust the derived column name accordingly.

There are two editors for this data flow component. To access the editors for Date Dims, double-click the Date Dims data flow component or highlight the component and click Show Advanced Editor or Show Editor. From the Derived Column Transformation Editor (Show Editor), you can develop the transformation through drag-and-drop or double-clicks.

You can also edit the transformation through the Advanced Editor using properties.

For more information about Derived column transformations, see Microsoft's MSDN article at Derived Column Transformation.