Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Can't figure how to create this SSIS Package HELP

Author  Topic 

mutlyp
Starting Member

20 Posts

Posted - 2014-09-08 : 19:48:46
Sorry new to this and I could really use some help.

I have view that has and ID number, a Min and Max value and a TotalCount columns. I then have a table that has an ID number and an Email address.

What I need to do is find all the records in the first table that the TotalCount value is either under the Min or over the Max. If so I then need to grab the Email address from the other table that has the corresponding ID number and then send an email to the email address I got from the second table stating that the ID number has gone over the Max or under the Min.

This seems so simple yet I can't figure our how to do it in SSRS as an SSIS Package.




Please help.


Thank you
   

- Advertisement -