Hi All,
I have a SSIS pkg which inserts/updates tables in my data warehouse. ( SQL Server 2008 )
I need to develop a mechanism to capture how many records added/updated against tables on data warehosuse ( daily basis) and store data onto a table as below.
Can you guys provide some advice on this please??
Table Name | Date | New Rows added | Rows Updated |
factSales | 2013-04-07 | 21 | 115 |
dimProducts | 2013-04-07 | 4 | 2 |
Regards
Mira
.
social.technet.microsoft.com/Forums
No comments:
Post a Comment