Post reply

Reading Footer of file and comparing it to total records in a file

  • February 25, 2008 at 4:09 am

    #154146

    Hi All ,

    I want to design a ssis package that will load the data from a file after checking the records specified in footer with total no of records received with that file.

    If it matches then load your data otherwise end the packages..

    Please specify the suggestion for this ..

    Amit Gupta

  • February 25, 2008 at 7:26 am

    #781540

    Data flow with a row count that is stored in a variable, add a conditional split that identifies the footer record and stores the count value in another variable

    Then return to the control flow and use the two variables to determine if you will continue.

    Either a constraint, a script, or insert variables into a table and use that to determine if you will continue.

  • February 26, 2008 at 6:33 am

    #781954

    Thanks Terri ..... its workng....:)

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

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