Post reply

Compare Source Tables rows and destination Tables rows

  • September 1, 2008 at 7:10 am

    #192133

    Hi,

    How to Compare Source Tables rows and destination Tables rows? I would like to abort the ssis process if both row counts are not the same.

    Please help. It is very urgent

    Thanks,

    Surya

  • September 1, 2008 at 6:49 pm

    #865785

    Select the count from both and see if they're equal?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 1, 2008 at 11:06 pm

    #865825

    Thanks for the reply. We can do this if both source and destination are on the same server. I am using AS400 as source and sql as destination. How do we do this with two different servers? Is there any component for comparing both table counts?

    Please help me...

    Thanks

    Surya

  • September 2, 2008 at 7:11 pm

    #866297

    Is there no way to simply do a COUNT(*) from each source and compare the two?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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