Can anybody suggest the best practice to capturue any error on SQL statement embaded on the EXECUTE SQL SCRIPT on SSIS?
It could be data error or any errors.
I added TRY and CATCH, but not sure that is the best practice. I've a Email task setup as the error path on the control flow which should capture the errors on the EXECUTE SQL TASK.
Thanks in advance for any help