I am new to the SQL Server 2005 Integration Services. We are building our first Data Watehouse and one of the ETL requirement is to use SSIS. Can anyone help me on how to put together the use of Lookup, Slowly changing Dimension, and Union All, in building my package. I have tried several times but I'm not getting a result. The objective is simple: 1. populate the dimension table (which is initially empty) 2. check the dimension if the business key/natural key already exist 3. if not create the record, if it does, apply historical SCD type 2 change. thanks for your help.