[SQL Server Data Warehousing] SSIS Auditing Mechanism?‏

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