Unable to select Variable to set date values in SCD type 2 , SSIS

1k Views Asked by At

I am creating a SCD type 2 dimension. In my destination table there are start time and d]end date columns. I am unable to select the variable to set date values in the SSIS package. Is this something I should configure in the SSIS package? If so, how? enter image description here

2

There are 2 best solutions below

0
On

Click on the 'variable to set date values' input box, and use SCROLL THE WHEEL MOUSE to change between variables.

0
On

Like the previous comment said - click on the Variable to set date values field and use your scroll wheel (In my case, I couldn't see that field until I resized the window).

And speaking in SCD context, System::StartTime should be the variable to use here, because all inserted data(or updated) will have the same ValidFrom date.