|the ultimate county fair strategery game - the quarter plow|
Anyway, it can be pretty useful. Some common uses of expressions within SSIS are when creating dynamic variables (evaluated as an expression) and derived column values in the pipeline. This post details an example of using an SSIS expression to calculate the quarter start date for each row in the pipeline as it passes through a Derived Column component. This same approach could easily be used to apply business rules to dates or other values in your source data on the way to your fact table.