Post reply

Rowcount

  • September 29, 2008 at 9:10 pm

    #124828

    I am not good in SSIS and need your advice. I have a scenario where i am transfering more than 10 million records from one database to another using OLEDB source and destination objects. This transfer task involves some transformations and it takes lot of time to complete which is understandable. now what i need is to track the progress of the task which i could display on the webpage from where i fired this SSIS package. For example, how many number of records have been processed for the particular task.

    Is there any object in SSIS which could help to find this count while it is transfering records.

    I had a look at rowcount field but i can only use it once the whole transfer task is complete.

    Any help is appreciated.

  • September 30, 2008 at 8:46 am

    #878906

    In your Data Flow window, there is a transformation called Row Count. You can use this to write the row count value out to a variable.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

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

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