Post reply

To validate # of excel rows(source) and sql server table(destination) rows are equal

  • February 19, 2008 at 11:52 pm

    #179311

    Hi,

    When exporting data from excel to sql server table, using SSIS package, after exporting is done, how would i check source rows are equal to destination rows. If not to throw an error message.

    How can we handle transactions in SSIS

    1. when some error/something happens during export and the # of rows are not exported fully to destination, how to rollback the transaction in SSIS.

    Any sort of help would be highly appreciated.

    Thanks,

    Alicia Rose

  • February 26, 2008 at 1:17 pm

    #782220

    i believe u can have mutliple destinations from source ...one to success dest and the other to failure dest ifrom source redirect all the failure rows to failure dest by which u can jus look at all the rows which caused error and u can make changes or rollback it....

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

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

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