Dear friends, if i'm talking about SSIS and SCD, SSIS SQL server 2008 works better than SSIS SQL server 2005 ? SSIS 2008 have a set based oriented operations to resolve SCD ? set based UPDATE for real? Can anybody give me please a real example about it? [*-)] Thank's
Check the following blog post... http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx
What is your requirement in terms of SCD, as 2008 feature is introduced by Ralph Kimball and it is fully supported.