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