asked on SSIS package for notification of changes
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.
ssis-order-compare.docx
ssis-order-compare.docx
Microsoft DevelopmentMicrosoft SQL ServerMicrosoft SQL Server 2005
Last Comment
lcohan
Did you considered Trigger(s) for this matter instead of SSIS? At the end, your Data sits in SQL database tables and that's where you could trace the "change" in real time by using INSERT, UPDATE, and DELETE triggers to do whatever comparison you need then send email or any other action.
ASKER
I will look into the triggers but I dont know how it will work with 2 different databases. I am running a query against our main sap db to get a data set ( any orders that are past due that we have stock on ) Initially i put this into a seperate table then rerun the query comparing results. I want this to run every 30 minutes and send an email anytime new stock is added for a past due order or a new order goes past due that we have stock for. I will look into triggers and see what I find but any help is appreciated.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.