Hi Phil,

So yes, records are being inserted into the csv file using an Informatica workflow. One out of the two targets is this csv file. Most of the time records go as insert and into the other target (database) table. But if there is an update in one particular column the record is sent to this csv file.

I won't go into the Informatica details more as m we are talking here about SQL and also my aim is to do this email part using SQL Sever.

Regarding your point on getting the row count from that transformation, although the Informatica software does have that feature of row count but that works well only when you have single target. For multiple targets, it won't be an ideal choice. Hence, I am trying to get the row count at and send the mail at the database level(SQL Server in my case)