I have a Script Task in SSIS 2005. I want this task to log any errors that may occur but I do not want to fail the task.
My reasoning is that this system has a ForEach container around the Script Task. The script task is connecting to multiple servers and querying data. If there is a problem connecting to a server, I do not want the task to fail. I want to log the error and continue processing the other servers.
I have a try/catch block currently in my code. This will cause the script to report no failure at all if there is a problem.
I've also tried using the Dts.Log method, but I'm not entirely sure how to use it or if it's the correct approach.