Top 10 SQL Server Integration Services Best Practices

Check out this URL for best practices for SSIS

http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

Info: Sort and Merge Components vs. Lookup Component

Worth reading this article..

http://consultingblogs.emc.com/jamiethomson/archive/2005/10/21/2289.aspx

Learn SSIS : SCD - Slowly Changing Dimensions transformation

Slowly changing dimension transformation was one of the mystery transformation for me till now, as i never had chance to actually implement it. So today i block my time to implement this transformation by taking a simple example.


The concept of slowly changing dimension is explained very well and in detail on wikipedia, i would request readers to have a look at below link if you are not aware of SCD concept.

http://en.wikipedia.org/wiki/Slowly_changing_dimension

Before starting on our example, let me give you some glance of the SCD