Hi, I have to use Slowly changing dimension component in my package but when I selected table I couldnt see one column in dimension column list of SCD component. Please suggest me to get all columns from table into dimension list of SCD because missing column is business key for my task and needs to have to be there. Using SQL Server 2008. Ane suggestions will be appreciated. Thanks! CPatil MCTS 2008 & 2005 , MCITP 2008 -- Please remember to mark the post as answered if it answers your question.

What data type is this column? Talk to me now on