Detailed Error information Script Task

• cpeet

  Valued Member

  Points: 66

  More actions

  August 24, 2011 at 2:35 pm

  #242267

  I have a script task that I use to do an HTTP post to a web service and that part is working fine. However, when the web service returns an error I set the task result as failure, and I would like to pass that detailed error onto the package so when it errors it doesn't have some generic error like Script task failed. I wasn't sure if this was even possible, but I've done a bit of research on google and this forum to no avail. Does anyone know how this can be accomplished if at all?

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  August 26, 2011 at 5:14 am

  #1373661

  You can log custom errors by using the DTS.Log command in the script task.

  Make sure you enable logging on the script task, and include the specific event that captures the message from DTS.Log.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP