Need some help with error handling. I'm using SQL adapter to insert records into the database. I read these records from a flat file. For my send port sending these records to be inserted in the database, I have set the Delivery Notification property = Transmitted. If any error such as primary key voilation or invalid data format occurs then they are caught using the DeliveryNotificationException. This is done exactly the same way as shown by Stephen Thomas's Sample given at
http://www.geekswithblogs.com/sthoma...1/01/9234.aspx
But doing it this way gives performance issues. It degrades the perforamance a lot. So much that to insert about 13000 records after reading it from my flat file into the database takes about 5 days. Is there any way around that these SQL errors could be caught and reported with better performance or is it that to report error from SQL only DeliveryNotificationException has to be used?
Any help in this regard would be appreciated.

Thanks a lot.