I'm working on a project that will load data from a text file into the database. I've created an SSIS package that loads the data into staging tables and then I have a sql statement that inserts the data into the correct production tables.
My question is what is the best way to validate the data using SSIS?
i) Invalid or missing values (e.g. bad dates. non-numeric data in numeric fields) and then produce an exception report.
Please Help as I need to have this done soon!