How to find column which causing "Conversion failed" error I've run into quite a lot of issues specially when it comes to conversion errors:
convert(datetime, [fieldname]) or SELECT CAST([field2] AS int).
Imagine a large select statement with 30+ conversion or cast functions, or a complex view with conversions, or even an insert statement on a field with wrong data type. I get so much headache trying to exclude fields one by one to find the troublemaker.
Is there a way to find out which field and/or value is causing the issue? How do people troubleshoot these without having to go through an arduous process of going field by field? Is there a log or information message that can help?
How do people troubleshoot these without having to go through an arduous process of going field by field?

Exclude half of them.  If the error persists exclude half the remaining.  Repeat.