Hi Lempster,

Thank you for taking time to respond in detail to my inquiry. I have read through the two articles you've referenced and contemplated the information. The more I think through the situation, I believe doing a cross-database (which would be cross-server as well in my case) query would be best to generate a data source as referenced in the first article. I will do more research to figure out if this is feasible. What I can try in the meantime is do a data source from my web server database and use a lookup transform back to the enterprise database, output the No Match entries, and update the Active flags to 0 for these rows. Slow and somewhat painful, but it may work until I can get authorization to link the servers.

I am intrigued with the CDC idea and have read about it a bit today. I am a bit concerned with that approach on our enterprise database because the software we use (built by a third party) abusively flogs the databases relentlessly. :w00t: The database may slow down even more if that approach is used in our scenario.

Thank you again for your time. I will post back what we use for our interim solution.