I am a little new to SSIS so please forgive my ignorance.
I have a small project where every month i need to email various recipients depending on values within the table.
I am OK with extracting the data I require but have no knowledge of SSIS.
Is there a member who could guide me or pass a sample SSIS package that mails the result set of a query dynamically based on email addresses returned by the query.
each row of data would have columns with the persons email address and the subject and body.
Thank you all in advance
With Kind Regards