Check Dates

Check Dates derives a column, INTERACTIONRESPONSEDATEDIMID.

((INTERACTIONRESPONSEDATEDIMID < @[User::FirstDate]) || (INTERACTIONRESPONSEDATEDIMID > @[User::LastDate])) ? 0 : INTERACTIONRESPONSEDATEDIMID

There are two editors for this data flow component. To access the editors for Check Dates, double-click the Check Dates 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.