SSIS - how to send email

nononame2021 261 Reputation points
2022-06-01T06:31:10.833+00:00

i am using VS2012, my SSIS going to generate excel and then pick up the generated excel to send email in SSIS sql job agent.

how can i do that? any reference guideline.

SQL Server Integration Services
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 47,586 Reputation points
    2022-06-01T06:36:41.163+00:00

    By using a Send Mail Task
    Or a bit more complex by using a .NET script task: Sending an HTML Mail Message with the Script Task

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.