Unanswered: DTS runs OK still returns failure message
Has anyone come across the following behavior....
I am executing a DTS package from an ASP page using a LoadFromPackage call. The package runs a Win 32 process, performs a SQL operation and a data pump. My data is imported without a problem and everything looks great. I see success messages for all steps in my log file. However, I get a failure method from each step returned in from my Execution Result call.
Has anyone experienced phantom error messages like this before? I suspect it's permissions related but who knows.
FYI: Here is the ASP code
Dim objPkg, strError, iCount
'Create and Execute the package
Set objPkg = Server.CreateObject("DTS.Package")
'Check For Errors
For iCount = 1 To objPkg.Steps.Count
If objPkg.Steps(iCount).ExecutionResult = DTSStepExecResult_Failure Then
strError = strError + objPkg.Steps(iCount).Name + " failed. " + chr(13)
If strError = "" Then