Alternate option to DSGetLinkInfo
Posted: Sun Oct 24, 2010 1:43 pm
Friends,
Currently I'm working on a task which requires me to update the log table with the number of records processed each time the job is executed.
The design of the job is quite simple. It extracts data from 2 tables in the source db and writes to 2 tables in the destination db
STBL1==>Transformer1==>DTBL1
STBL2==>Transformer2==>DTBL2
The requirement is to update the log table with the number of records extracted from the source and written to the destination db.
I wrote a custom routine which uses "DSGetLinkInfo". But the problem is that I have wait for the completion of the job to invoke the custom routine to get the number of records processed in the link.
Is there any other way to get the number of records processed through a link from within the job
Thanks
Yamini
Currently I'm working on a task which requires me to update the log table with the number of records processed each time the job is executed.
The design of the job is quite simple. It extracts data from 2 tables in the source db and writes to 2 tables in the destination db
STBL1==>Transformer1==>DTBL1
STBL2==>Transformer2==>DTBL2
The requirement is to update the log table with the number of records extracted from the source and written to the destination db.
I wrote a custom routine which uses "DSGetLinkInfo". But the problem is that I have wait for the completion of the job to invoke the custom routine to get the number of records processed in the link.
Is there any other way to get the number of records processed through a link from within the job
Thanks
Yamini