Post reply

Count the number of line transformed

  • August 2, 2004 at 9:42 am

    #60176

    Hello,

    I'd like to generate a file with the number of line transformed.

    My DTS copies all data from 2 oracle tables to a SQL server tables without any other modifications.

    What should I do to get the number of lines imported ? (like I run the package by SQL server manager interface)

     

    thanks a lot for your help !

    Ts

  • August 2, 2004 at 2:41 pm

    #517331

    Turning on package logging will record the record count for each task in a log file that you specify. 

    -Open the package in DTS Designer

    -Click on package properties

    -Click on the Logging tab

    -Fill in the Error File name and click OK

    -Save the package

    Greg

    Greg

  • August 3, 2004 at 5:38 am

    #517414

    thanks, I solve the problem by using a activex componant with the RowsInError and RowsComplete properties.

    Ts

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

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