Post reply

Count the rows

  • September 25, 2007 at 5:40 am

    #118722

    Greetings!!

    I am using a foreach file to loop through mdb files kept in a folder and then transfer them to Sql server.

    I want to do the following - 

    Sum the total no. of rows in mdb while the package executes

    Write them to a database (RowCnt, PackageNm, UserNm) 

    Note: Total  = Total rows in all mdb files. so if there are 10 mdb files with 10 rows each, total = 100. 

    I saw a RowCount transformation..but everytime i run, the value of variable declared for Rowcount, changes. How can I get a sum of all rows in of all mdb's.

    Please support your answer with some code for this newbee.

    thanks

  • September 25, 2007 at 7:05 am

    #735994

    I think you need another variable with package scope that you can increment with the value of the variable that has RowCount scope.  I believe you would do this using the script component and a little vb code.

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

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