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;
}