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
asked Mar 29, 2012 at 09:33 AM in Default
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!
answered Mar 29, 2012 at 01:49 PM