I am trying to creat an ssis package that compares 2 data sets and updates the 2nd data set to match the first. Anytime there is a change to data set #2 send and email notification with the results. I have done a little bit with integration services in the past and have gotten the send mail with results from the query to work fine but I want to add few other steps and lessen the email by only sending when the data has changed. I am attaching a small flow diagram of what I am looking for. Please let me know what compents to use while creating the ssis.