I know CDC functionality wasn't implemented until SQL Server 2008, but I've seen various posts on other forums in which users claimed to have done something similiar using SSIS components in SQL Server 2005. Unfortunately none of the posts are very descriptive. Does anyone know where I can go to find an example of implementing this functionality in SQL Server 2005?
Thanks