October 27, 2009 at 8:07 am
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
October 27, 2009 at 12:20 pm
You could define a variable for each of your validation types and use the RowCount transformation to get the count of the rows that go down each of the validation type pipelines. At the end of your package, use the values in the variables to report on.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply