soujanya
Hi i need to trace the modification in table like insert,delete,update and if any modifications has occurred it sholud send mail how can we do in ssis plz help me out
December 9th, 2010 2:48am

you don't need SSIS, you can do it with CDC(Change Data Capture) look at this article for start: http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2010 2:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics