Input File Validation

Hi,

I am quite new to SSIS (I was a DTS developer) and I have a specific requirement to validate all incoming data using regular expressions. For each row in my input file, all columns will need to be validated against an expression. We have approx 60 different input files (a combination of xml and text files) with column counts going from 10 up to 120.

Also each input file will contain a footer which will need to be validated for record counts.

I would like the solution to be as generic as possible as the requirements for each file are similar -the only difference being the column names and the expressions to check against. I would really rather not have a different data flow task for each input file type as there are so many.

Can anybody suggest the most efficient/reusable way to do this? What I was thinking of was this:

Split the input file into detail/footer
create a temporary table based on the input file type with CHECKconstraints (regular expressions) for each column
for each detail record load it into the temp table
redirect any failures to another destination e.g. sql error table

Any other ideas would be very helpfull

Many Thanks
Gaye