Forum Discussion

sparvathaneni's avatar
sparvathaneni
New Contributor
8 years ago

Need counts of 20+ Tables from Source & Target into a .xls file

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 designin...
alchemiz's avatar
alchemiz
Contributor III
3 years ago
Copy LinkReport

If the source is MSSQL then you can use SQL Execute snap and run below query

select object_name(object_id) as [table name], sum(row_count) as [row count]
from sys.dm_db_partition_stats
where index_id < 2
– and object_name(object_id) in (‘tbl1’,‘tbl2’,‘tbl3’)
group by object_name(object_id)