Number of Rows Transfer by DTS

[sanjoo306]

HI All,
My Extration Program is working fine.
I am using DTS through VB and transfering data from one database to another. But now I need to know how many rows transfer from each table from scource to destination is there any property of DTS object in VB.

Thanx in Advance

 

[wbeetge]

Create a global variable in your DTS. In one of your transformations, add 1 to that global variable each time it passes a record.
When you are done with the DTS, you can query and display it from VB:

goPackage.execute 'execute you package
nvar = gopackage.GlobalVariables("Records copied&quot.value

Msgbox nvar & " Records were transformed"