Hi, I have question regarding send mail task in SSIS.
I am trying to have SSIS to send alert email based on number product customer purchase, and I am not sure if this is possible with SSIS.
Our department managers wants to get alerted on items customer purchase, and if certain item sold more than 150 times (throughout whole time), they want to get alerted via email with item information (Item number and name).
Initially, I was going to just send email report on items with 150 transaction or more but problem is managers want alert, not report. They only want to get alerted when item pass 150 transaction. Once transaction goes over 150 times, they don't want to get
alerted again and again for same time.
This is what I did so far and stuck...
1. Populate table with Item Number, Item Name and Sold Qty - Since I only have read-only access to transaction database, I created SSIS data flow package to dump all item transaction information to other database. I also created a tabl
View Complete Post