Hi - i am looking to capture counts of source and target tables into .csv file for data verification on a daily basics.
My Question is i was able to get a table count into a csv file after designing a snap
SQL Select ->Aggregate -->CSVFormater->Filewrite->Email (Looks ok ) Result - Good.
I have 20+ should i do the same process as above for each table ? or any simplified way of achieving the result ?
Any inputs is greatly appreciated .Thank you