Exceptional Report In SSIS

[karthika9]

Hi all,
Can anyone assist me of how can I generate exceptional report
in SSIS Package. The exceptional report is on Error's during the data validation and cleansing.
My Req is like this:
I get Flat File Daily or Weekly basis... I have to do Data cleansing and Data Validation Using SSIS...
So every time I do any kind of data validation like Removing Invalid Data I redirect those Invalid rows
to another text file.....So Nor I have to generate a exxceptional report about those error for example
If I got a file of 1000 rows In which 100 rows were Duplicate, 50 rows were did not meet the constraints
requirement, 60 rows were not of correct data type...so Now my Exceptional report should include all these
details.....In the final step My file will go for a status check like if more than 50% of my rows are invalid
then it will be rejected and If less than 50% are error rows then The file is accepted with rejects and If
there are no error then File is accepted wihout rejects....so all this information shoud be included in
exceptional report....Please help me out as I am not able to find out any way till now to get this report....
Thank you in advance

 

[MDXer]

Build a custom logging solution that writes the event information to SQL tables, such as that outlined in Project Real. You can then build reports off of these tables.