This should be an easy one. I have a DF that performs a conditional split on a piped delimited file based upon the data value in the first column. There should be one logical header record and one logical trailer record with x number of detail rows. The detail rows get passed on to the temp output file via the split. All this works well. What I want to do is to validate that there is exactly one header and one trailer entry that is excluded from the output file via the ‘other’ path from conditional split. If I am missing a header or a trailer entry I want to fail the task or the package. I'm unsure how best to implement this. Thanks in advance, RJ

After I thought about it some more I realized I could just send the header/trailer rows to a database table and continue with the detail rows as before. This actually gives me some options regarding validating the number of detail rows that I wasn't even looking at before. Still there has to be a better that writing it out to a quasi temp table.

You can also use a row count on both header and trailer and then use a precedence constraint to a script task that would force a package failure while raising the proper error. Either method should work for you.Please mark answered posts. Thanks for your time.

Thanks Eric, That's exactly what I ended up doing and then I read your reply. Good to know my instincts are still in tact. Thansk again.