script task logging using DTS.Log

• sharath.chalamgari

  SSCertifiable

  Points: 5680

  More actions

  July 26, 2010 at 5:57 am

  #157102

  Hi in my script task iam using dts.log

  here in my below code if my count is 0 then i want to fail the task, so i am giving the Dts.TaskResult = (int)ScriptResults.Failure;

  but actually when i fail the task it is not logging the message.

  is there any property that i need to set or how to proceed from here any idea!

  if (Dts.Variables["GlobalMatchCount"].Value.ToString() == "0")

  {

  strbldr.AppendLine("++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");

  strbldr.AppendLine("Package processing HALTED:There are no dates matching Run Date");

  strbldr.AppendLine(" Run Date : " + Dts.Variables["THERUNDATE"].Value.ToString());

  strbldr.AppendLine("+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++");

  Dts.Log(strbldr.ToString(),999,null);

  Dts.TaskResult = (int)ScriptResults.Failure;

  }

• Jonathan Ely

  SSC Veteran

  Points: 209

  More actions

  July 27, 2010 at 3:08 am

  #1198594

  Have you set the script component logging on?

  I think it's called ScriptTaskLogEntry