execution time

Aug 12, 2009 at 2:39 PM


I'm really novice with SSIS but found time for SCD really awful. That what I've tried Kimball Method. I don't know where's the problem I've tried both methods on input 450 000 lines in a new table. It took 8'' with native method and I've stopped the Kimball package after 20''.

Maybe there are things to know....


Aug 13, 2009 at 4:52 PM

Hi Nad,

Looks like you're experiencing the same thing as identified in Issue 1953 (http://kimballscd.codeplex.com/WorkItem/View.aspx?WorkItemId=1953).  If you're comfortable downloading and ocmpiling your own component, there is a code fix listed in that issue.  If not, you may want to try v1.5, where that issue has been addressed, or try some of the workarounds listed in that Issue.

Sorry for the runaround!  By my estimates, you should be able to process that dimension in under a minute.

Aug 14, 2009 at 8:29 AM

Hi Toddmcdermid (difficult :-)  ),

Thanks a lot for your answer. I'll try to fix it but not yet. I'll let you know about results.