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
SSIS - how to send email
nononame2021
261
Reputation points
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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1 answer
Sort by: Most helpful
-
Olaf Helper 47,586 Reputation points2022-06-01T06:36:41.163+00:00