|
I have setup an SSIS package for a client. Mostly scripts and jobs within the package. However there are scripts that are checking for duplicate records. Should the job return any records, then an e-mail notification needs to be sent out to the DBAs and then if there are no records returned then the package should move onto the next task. On records returned, i need for the package to execute another ssis package to update the duplicates or simply move onto next step. Immediate responses are appreaciated, i've been trying to get this to work for more than an hour now. thanking you all in advance
(comments are locked)
|
|
No worries! =) There is an 'Execute Package Task' that you can use to execute the next package along with the 'Send Mail Task'. You can adjust your script tasks to set a variable to a value, say 'TRUE' if duplicates are found and then you can set a precedence constraint to evaluate an expression and check to see if that variable is 'TRUE'. This might help explain it better: http://www.sqlis.com/sqlis/post/Introduction-to-Expressions-on-Workflow.aspx. It's an older article, but it should point you in the right direction. Hope this helps! John, Thank you so much...some light to my thoughts on this. Much appreciated.
Mar 30 '12 at 08:22 AM
Pinkett
Very welcome! Glad to help!
Mar 30 '12 at 12:18 PM
JohnM
(comments are locked)
|
Forgive me, but you mentioned a couple of things in your post. What specifically do you need help with? The email notification or the execution of another SSIS package to process the duplicates? Both?
Hi JohnM I actually need to know how to tell the SSIS package to run another package if there are any records returned, if there are no records returned then continue. The e-amil notification is simply to notify myself that there were records returned. Hope that answers your question? Forgive me for not being clear
Thanks