have one script that works fine. I am doing the exact same thging with this new script and it runs fine from C# on my desktop and runs fine from SS on the server but comes back with a failure when trying to run from C# on the server. Is there any additional info I can retrieve about the problem All I am getting right now is "Failure" from the result field.
if (result == DTSExecResult.Failure)
{
Console.WriteLine("Task failed or abended");log.Error(
"Problem with DTS Script");log.Error(result);
}
else