CDC Standard for SSIS input and Proactive Caching

Jun 29, 2012 at 3:42 PM

Hi, is there anyone using CDC Standard to feed add, changes and deletes into a ETL package for use in Proactive Caching scenario?  or even just into an ETL package? 

I'm wondering what your experience has been even if your using it for other purposes than what I'm trying to do?  I have used Enterprise CDC and it works great but unfortunately the server that I need the CDC is on a Standard version.  So I saw this and was intrigued.

I would be running CDCStandard in a production enviroment and I'm a little worried about the triggers. Would it be better to use another method such as a transactional replication solution and then use Enterprise CDC in this scenario?

thanks for any insight,

Tom