Post reply

Logging record counts from Transform Data Tasks

  • January 6, 2004 at 9:22 am

    #358787

         Is there a way to grab the number of rows processed in a transform data task? When you run packages interactively, you get a rows processed number with each transformation. I'd like to grab this number and log it somewhere, so I could compare it to the source data for  completeness.

         I have a lot of packages, with a lot of transformations in each (populating a reporting database). I'd like to avoid having to run a script after the import process saying something like 'insert into log.dbo.tbl select count(*) from tbl1', etc.

     

     

  • January 6, 2004 at 11:32 am

    #488851

    You'll need MULTIPHASE DATA PUMP to achieve this.


    Joseph

  • January 7, 2004 at 3:34 pm

    #489058

    You could add an ActiveX Script task that check the properties of the datapump task. This way you'll not only get a count of the rows processed but also the rows in error.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply