We typically use Job Control batches to run all of our jobs. This allows you (among other things) to use 'DSGetLinkInfo' in the batch after the job completes and fetch the row count that went down any link. In your case it would be the link that handles the inserts into the table you want to track. You can then log it and/or pass it to another job as a parameter.
HTH,
-craig
URGENT Problem...
Moderators: chulett, rschirm, roy
Just make sure you have the syntax right:
Result = DSGetLinkInfo(JobHandle, StageName, LinkName, InfoType)
Use the *handle* to the job, not the actual job name. StageName should be the transform that feeds the database stage and LinkName is the link between the two. Case is important. Use DSJ.LINKROWCOUNT for the InfoType.
Make sure you are using the handle of the job that just ran, the job that contains the Stage and Link in your function call, not the one you wanted to pass it to. Should work fine.
-craig
Result = DSGetLinkInfo(JobHandle, StageName, LinkName, InfoType)
Use the *handle* to the job, not the actual job name. StageName should be the transform that feeds the database stage and LinkName is the link between the two. Case is important. Use DSJ.LINKROWCOUNT for the InfoType.
Make sure you are using the handle of the job that just ran, the job that contains the Stage and Link in your function call, not the one you wanted to pass it to. Should work fine.
-craig