SCD Wizard not holding values

Topics: Possible Bugs/Missing Features?
Jul 26, 2011 at 7:30 AM

Hi

I am using version 1.5 of the wizard. I have posted a previous discussion about problems trying to get 1.6 working with SSIS 2005.

I am finding that some of the values are not sticking in the wizard. I have listed the ones that I know about below. Setting these values and going out of the wizard and back in again results in the previously set values being set to blank:

 

1. Tab - Inferred Member Behaviour - False Value keeps resetting to blank

2. Tab - Auditing - New SCD2 Output Counter - Keeps resetting to <not used>

3. Tab - Auditing - Row Change Reason - Default value for new rows keeps resetting to blank

Are others experiencing these problems. I have worked around 2 of these three by hard coding the values in the different output branches.

Are there any plans to fix this.

Thanks

Feb 2, 2012 at 8:48 AM

Hello,

I'm using v1.6 on Sql Server 2008r2 sp1 64bit on WS2008R2 64, and I'm experiencing the following behavior:

Tab - Auditing - New SCD2 Output Counter - Keeps resetting to <not used>

As a workaround i put a RowCount at the output of "New SCD2" pipeline

 

Thanks,

Adrian