How to get Rows Processed from Transform Data Task - SQL 2000 DTS

[ReportDr00]

Hello

Is there a way to store the number of rows processed between source and destination using Transform data task in a global variable ?
I would like to insert this information in sql server table to keep log

really appreciate your input

Armani

 

[drtree]

Hey,

I did some googling on this, and it looks like you'll have to go in C# and monitor the DTS package (specifically the OnProgress event).

Hope that helps...

doc tree