Validating Row count in a Tab Delimited File within an SSIS Package RRS feed

  • Question

  • Hi,

    I am about to start a project and I got some sample input files.

    The files are tab delimited.

    The file contains data rows and a trailer row. The trailer row specifies the total number of rows.

    One of the requirements is that we validate the total in the trailer row against the number of data rows present in the file itself.

    Can this be done easily via SSIS? What is the best way to achieve this?

    Thanks in Advance,


    Thursday, March 21, 2013 3:17 PM


  • You can read the number of records in the file using a script task and match it with the trailer value. If both match then load the data using a data flow task.

    Nitesh Rai- Please mark the post as answered if it answers your question

    • Edited by Nitesh Rai Thursday, March 21, 2013 3:29 PM
    • Marked as answer by Eileen Zhao Thursday, March 28, 2013 8:08 AM
    Thursday, March 21, 2013 3:29 PM