Forum Discussion

tk_lawson's avatar
tk_lawson
Copper Contributor
Jul 07, 2025

Setting Up SCD Type 2 using "Variable to set date values"

I am creating an SCD type 2 dimension and using start and end dates to identify current and expired records. In my destination table, there are start date and end date columns. I am unable to select the variable to set date values in the SSIS package. When I click in the "Variable to set date values" box, I don't see a drop-down to select my system variables from. I want to use the System::ContainerStartTime. Do you think this is something I need to configure in the SSIS package? If so, how?

 

No RepliesBe the first to reply

Resources