Need rowcount for Data pump within DTS

• John Chiu

  SSCrazy

  Points: 2619

  More actions

  February 9, 2005 at 10:58 am

  #165903

  Is there easy way to get rowcount on the data pump within DTS package ? I was asked to find a way to find how many rows were pump in thru. the DTS package to our production. This DTS read both a text and Excel file. My manager want to know how many rows are pump to production on each execution and send out an Email to the client (to match up). The data pump was directly loaded to the production tables which does not have identity key or datetime stamp.

• xyz

  SSCommitted

  Points: 1653

  More actions

  February 9, 2005 at 12:25 pm

  #541447

  look up here:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspscrprop_58ft.asp

  DestinationRowsComplete Property

  DTSTransformPhaseInfo.DestinationRowsComplet

  hope it will help.