You would probably need to have the SQL task logging the error as an OnError event handler task at package level (or a suitable executable below that).