Can't figure out how to create this SSIS package please help

Question

Can't figure out how to create this SSIS package please help

mutlyp

SSC Enthusiast

Points: 103
More actions
September 8, 2014 at 5:50 pm

#299159

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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

mutlyp (9/8/2014)
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.

You'll get more SSIS help by asking in the SSIS forum. Either way, the first thing you need to do is create your query, you can do this all in T-SQL, so SSIS isn't really needed. Post some DDL and some sample records and someone can most likely help you.

HTH,

Rob

KoldCoffee SSCoach Points: 18971 More actions · Answer 2

Did you get help you needed? After joining the tables on id you can filter WHERE totalcount is > max and < min..ofcourse in sql it's easy. I don't have clue how you'd do this in ssrs (sceptical) but in Ssis it could be done. But then you have to decide how often you want to query the data to check for changes.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

mutlyp (9/8/2014)
Sorry new to this and I could really use some help.
This seems so simple yet I can't figure our how to do it in SSRS as an SSIS Package.

Can you elaborate on what you're trying to do? Doing it in SSRS as a SSIS package makes absolutely no sense to me.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

mutlyp SSC Enthusiast Points: 103 More actions · Answer 4

Thank you for the responses. Decided to use a Stored Procedure to do what I wanted and then just scheduled the store procedure to run.

Thanks

KoldCoffee SSCoach Points: 18971 More actions · Answer 5

send an email to the email address I got from the second table

how did you handle that part?

mutlyp SSC Enthusiast Points: 103 More actions · Answer 6

Not sure what you mean. What part are you talking about.

thanks

KoldCoffee SSCoach Points: 18971 More actions · Answer 7

sending email for email addresses that fall below and above min and max?

mutlyp SSC Enthusiast Points: 103 More actions · Answer 8

in the stored procedure I grabbed each record and checked if the count was > or < the max min values if it did I used sp_send_dbmail to send the email.

Is that what you were asking about?

KoldCoffee SSCoach Points: 18971 More actions · Answer 9

KoldCoffee

SSCoach

Points: 18971

September 11, 2014 at 5:00 pm

#1744959

Yes, very cool. Thanks for sharing.