Page 1 of 1

Job Information

Posted: Mon Jul 19, 2010 6:17 am
by jyothisdasms
Hi,

I need to load the job details like source stage and target stage names,Row count etc to a text file.Can any one help me to create a job for this?

Thanks and Regards

Posted: Mon Jul 19, 2010 6:36 am
by priyadarshikunal
Just download ETLStats from Kim Duke's website and modify it as per your needs. No need to reinvent the wheels.

Posted: Mon Jul 19, 2010 6:36 am
by ArndW
You will need to use calls to DSGetJobInfo(), DSGetStageInfo() and DSGetLinkInfo() to get this information. Are you sure that you want to program this yourself or can use existing code such as that from Kim Duke?