sql server dts: Hi all,
I would like to catch progresscount from DTS package at the time of execution.

Once we enabled DTS package log, all package execution details are inserted
in to respective tables in MSDB data base.

Before inserting Progresscount in to respective table I would like to catch
progresscount.

Please help me the same.

Thanks and regards,

I think you mean catch the progresscount for a DTS step i.s.o. package? I
have not done this before, but you could try using the multi-phase datapump
(right-click Data Transformation Services folder in Enterprise Manager ->
click "show multi-phase pump in DTS designer"

In your package click the transform data task (datapump) -> tab
"transformations" -> select phases filter: post source data

You can write an ActiveX script here that executes after all data has been
transformed, but before the datapump step is done. Try to retrieve the
ProgressRowCount property of the DTSDataPumpTask via the DTS object model.
Use Google, as I don't have any code at hand for you to do this.

Hello Rajesha,

To get this kind of information you would ideally want to consume the events
from package execution using something like VB.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]