SSIS Package

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

more ▼

asked Mar 29, 2012 at 09:33 AM in Default

avatar image

30 13 14 15

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?

Mar 29, 2012 at 12:44 PM JohnM

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


Mar 29, 2012 at 12:48 PM Pinkett
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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!

more ▼

answered Mar 29, 2012 at 01:49 PM

avatar image

14.2k 3 7 14


Thank you so much...some light to my thoughts on this. Much appreciated.

Mar 30, 2012 at 08:22 AM Pinkett

Very welcome! Glad to help!

Mar 30, 2012 at 12:18 PM JohnM
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 29, 2012 at 09:33 AM

Seen: 783 times

Last Updated: Mar 30, 2012 at 12:18 PM

Copyright 2018 Redgate Software. Privacy Policy