SQL Server Integration Services (SSIS) has superseded DTS in SQL 2005 and has some great new features beyond better performance, more scalability and an integrated debugging facility. As if that was ...

Note also that the StartDate and EndDate attributes are populated using the Slowly Changing Dimension transform or similar logic within the SSIS ETL incremental load process. For each customer move, ...