Hi,
It can be done using SSIS script task component or Send Mail Task. Let us have a chat on this if you want me to help you with this job.
Here's a brief about myself -
Basically I'm an ETL developer with 7 years of experience in MSBI with 15 years of total software development experience. I've extensively worked on data migration and cleansing and data modeling. I've worked on BI projects in Telecom and Realty sector in the last 7 years, mostly involved in the creation of ETL packages, used different data sources like Oracle, SQL Server, Ms Access, Text files, Spreadsheets, XML files etc. using Microsoft SSIS. I was always involved in writing Stored Procedures, Functions and complex ad-hoc queries and data modeling work throughout my career.
Following is my skill set :
Database/Datawarehouse - SQL Server, Oracle
MSBI : (SSIS, SSRS, SSAS)
Dotnet - C# (core), ASP.Net (core)
I look forward to hearing from you.
Thanks