I receive the error " There must be at least one column type of Key on the input of a Slowly Changing Dimension transformation. Set at least one column type to Key." The strange thing is that I HAVE a business key defined in the transformation!! I can also not believe there are no step-by-step instructions out there that explaibn how to implement the SCD transformation :-( Can anyone help with either

IN the SCD transfomration configuration editor, atleast one key has to be selected based on which it decides whether an update or an insert should occur for the particualr dimension. Are there any NULLS for the business key : FROM Books online: The Slowly Changing Dimension transformation requires at least one business key column. The Slowly Changing Dimension transformation does not support null business keys. If the data include rows in which the business key column is null, those rows should be removed from the data flow. You can use the Conditional Split transformation to filter rows whose business key columns contain null values.http://deepaksqlmsbusinessintelligence.blogspot.com/ Happy to help! Thanks. Regards and good Wishes, Deepak.

Here is a step by step work through: http://www.bimonkey.com/2009/07/the-slowly-changing-dimension-transformation-part-1/ and http://www.bimonkey.com/2009/08/the-slowly-changing-dimension-transformation-part-2-type-2-dimensions/ The SCD is easy to implement, but unfortunately also very slow when more than a couple of records are processed. Here are a few alternatives: http://microsoft-ssis.blogspot.com/2011/01/slowly-changing-dimension-alternatives.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com