I'm using DTS and need to catch the error message. how to retrieve the error messages. i have used workflow as "onFailure" in the DTS. so when the error is generated during the process then, error subroutine should catch the error message.
Is there any method to get the SQL Server messages??????