Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: error running dts process task using activex script.

    hi,
    i'm having some trouble running a dts execute process task. when i run the dts i get an uncommented error, could anyone help? here is my activex script:

    Function Main()
    Dim oPackage
    Dim oStep
    Dim oTask
    Dim oCustTask

    Set oPackage = CreateObject("DTS.Package2")
    oPackage.FailOnError = True

    Set oStep = oPackage.Steps.New
    oStep.Name = "ProcessStep"
    Set oTask = oPackage.Tasks.New("CreateProcessTask2")
    Set oCustTask = oTask.CustomTask
    oCustTask.Name = "ProcessTask"
    oStep.TaskName = oCustTask.Name
    oPackage.Steps.Add oStep
    Set oStep = Nothing

    oCustTask.ProcessCommandeLine = "cmd"
    oCustTask.SuccessReturnCode = 0
    oCustTask.Timeout = 30
    oCustTask.TerminateProcessAfterTimeout = True

    oPackage.Tasks.Add oTask
    Set oCustTask = Nothing
    Set oTask = Nothing
    oPackage.Execute
    Set oPackage = Nothing

    Main = DTSTaskExecResult_Success
    End Function

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What do you mean uncommented error ? Have you tried this within vb - are you running this in asp ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •