February 17, 2010 at 11:09 am
I have a DTS package that gives me the above error during its execution. It occurs while running an ActiveX Script task. But the ActiveX Script has no code in it that refers to a uniqueidentifier.
Here is the script:
'**********************************************************************
' Script Visual Basic ActiveX
'************************************************************************
Function Main()
Dim objDtsPkg
Dim objStep
Dim vResultat
If DTSGlobalVariables("cDtsDePurge").Value & "" <> "" Then
Set objDtsPkg = DTSGlobalVariables.Parent
Set objStep= objDtsPkg.Steps("ExecutePackage_PurgeDeLaBase")
DTSGlobalVariables("cError").Value = " ; Purge database every " & DTSGlobalVariables("intPurgeBase").Value & "day(s)"
DTSGlobalVariables("cParamStep").Value = "06"
objStep.Execute
vResultat = objStep.ExecutionResult
Else
DTSGlobalVariables("cError").Value = " Our message."
vResultat = 0
End If
If vResultat = 0 Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
End Function
I'm wondering why this error message occurs. There is no reference to a uniqueidentifier in this script. The package however, where this task is run, is called by another DTS package. So I'm wondering if the call to this DTS has anything to do with it.
Help
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply