Count of number of records per link

bhanuvlakshmi · Post by **bhanuvlakshmi** » Tue May 31, 2011 5:07 am

Hi All,

My requirement is to insert the data in to the table at the same time i have to pass the total number of records processed through the link as a paramater to a stored procedure. for That i had

seqfle-->T/F-->ODBC

Agian from the same T/F i took an aggregator stage and stored procedure stage.

But I am not able to calculate the total nuber of records for the column or through the link.In aggregator stage i have to give grouping column and if it is so then it is not giving total records in the column.
Could any body please help me on this.

Please suggest me if there is any other way of calculating the total number of records in the column or records Through the link.

Please note this is parallel job and the database is SQL SERVER 2005

ray.wurlod · Post by **ray.wurlod** » Tue May 31, 2011 6:44 am

Download ETLstats from Kim Duke's website and use that. No need to re-invent the wheel.