Validate Source Table Row Count
Going back to SSMS within the jumpserver, copy the T-SQL script in a new query window, and execute:
**_Script:_**
SELECT 'dbo.Customers' As Table_Name, count(*) AS rows_count FROM SampleDB.dbo.Customers
UNION
SELECT 'dbo.Employees' As Table_Name, count(*) AS rows_count FROM SampleDB.dbo.Employees
UNION
SELECT 'dbo.Products' As Table_Name, count(*) AS rows_count FROM SampleDB.dbo.Products
UNION
SELECT 'dbo.Sales' As Table_Name, count(*) AS rows_count FROM SampleDB.dbo.Sales;
**_Output:_**
| Table Name |
Row Count |
| dbo.Customers |
19759 |
| dbo.Employees |
23 |
| dbo.Products |
504 |
| dbo.Sales |
6715221 |
**_Screenshot:_**
