Lookup Block Error Handling

I've ticked "If no matches are found, fail the record with the following error message" in a SQL Server Lookup Block but I would like more detail in the error, specifically the matching criteria values that failed to find a match, so that I know which record caused the issue. Can I include more detail in the error message? Can I throw an error of my own in an If/Else (If Result.RecordsMatched > 0 Then Do Next Step Else Throw Custom Error End)? Thanks.

(2) Answers