x

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

Pinkett gravatar image

Pinkett
30 11 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

Thanks
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

JohnM gravatar image

JohnM
6.8k 1 3 7

John,

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x937

asked: Mar 29, 2012 at 09:33 AM

Seen: 655 times

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