I use SSIS to import the .xlsx file into DB
I have somm INSERT UPDATE and DELETE query in SSIS,
finally will send the email to me, to tell me the jobs had been done.
But I don't know how to send the logs of INSERT UPDATE and DELETE query
I wonder if the email have following info. :
ABC SSIS had been completed.
No. of row had been import from .xlsx file : XXXX
No. of row had been updated in ABC DB : XXX
No. of row had been deleted in ABC DB : XXX