Error handling in biztalk server 2004

You might want to check out Todd’s white paper on the SQL adapter: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_Biztalk2004.asp

Off the top of my head I would think you could use delivery notification.