Sorry, I missed the Mere Mortals bit, I thought it was just .Net, not sure I'm going to be of much use to you!

Are you just doing this to try and find out why the records are failing to insert, debugging, or is going to the second database the long term solution?

Jon

>hi,
>
>the dataset contains many records, which come from a completely different source, so I want these records to go to the first database and if that fails for that record to fail over to the second database which has no triggers or rules, so I can track what is failing and what is not
>I hope that makes it clear :)
>cheers
>stuart