After manually executing a package, where do I find a log that shows the # of rows processed per table? I'm trying to verify my incremental loads are working properly
Solved
Execution Row Count
Best answer by JTreadwell
Hi Mark, great question! You can do this a few ways.
- Preview the Table, At the bottom of the preview dialogue, click the "instance" drop-down and select Raw. Then click Count Rows. This will tell you how many rows exist in the raw table. This will indicate how many rows were loaded during the last incremental execution.
- Execution Overview Log. Right-click on the table > View execution overview log. At the top, change the "measures" drop-down to "Raw rows". This will show a bar chart of the last few executions. You can also change the measures drop-down to "valid rows" to compare what was loaded incrementally vs, how many total records in the table.
+5Hi Mark, great question! You can do this a few ways.
- Preview the Table, At the bottom of the preview dialogue, click the "instance" drop-down and select Raw. Then click Count Rows. This will tell you how many rows exist in the raw table. This will indicate how many rows were loaded during the last incremental execution.
- Execution Overview Log. Right-click on the table > View execution overview log. At the top, change the "measures" drop-down to "Raw rows". This will show a bar chart of the last few executions. You can also change the measures drop-down to "valid rows" to compare what was loaded incrementally vs, how many total records in the table.
Is there any way to alert or e-mail if row counts are off between the source and target tables like when packages fail?
+5Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
