Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karthika9
Starting Member
8 Posts |
 Posted - 2009-10-26 : 20:28:07
|
| 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. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-27 : 05:12:05
|
| What are your requirements?Is this report in addition to logging? |
 |
|
|
karthika9
Starting Member
8 Posts |
Posted - 2009-10-27 : 10:05:43
|
| 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.... |
|
|
|
|
|
|
Exceptional Report