question

jacobmat9 avatar image
jacobmat9 asked

automated mail if the result shows '0'

Hello, I have two ssis packages which run daily and hourly. 1. Daily sales and 2. hourly sales. These packages are already scheduled to run on a particular time and it send out the email to the group. But the problem is it sends out the email if the results/ numbers in the report shows "0" or "xxxxx" numbers. I want and automated email to be send to a different user or user groups if result shows "0". How can i do that ? and where ? Thanks Jay
automationmail
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
neeehar avatar image
neeehar answered
did you try precedence constraints?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jacobmat9 avatar image jacobmat9 commented ·
I tried precedence constraints and that is a good option. But i have some questions on that. I have this SProc which brings in sales from different places and create a temp folder and that temp folder is altered and changed everyday like a loop. Can i create the precedence constraints straight from that SP in the ssis package directly or should i be using a execute sql task in between ?
0 Likes 0 ·
neeehar avatar image neeehar commented ·
the way i used constraints is based on the data captured on to a variable. I would go with an execute sql task option.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.