Post reply

error: Task DTSTask_DTSDataPumpTask_2 was not found

  • December 7, 2006 at 6:39 am

    #67895

    I’m getting an error with a task inside a DTS package and I’m hoping that you may know something about it. I received the following code (see below) for an application that we are standing up and I don’t know how to fix it: 

    Here’s a snippet of the code I’m referring to. This code is inside an ActiveX script task that is running inside of a DTS package:

    ------------------------------------------------------

    Function Main() 

    dim oPackage

    dim oPumpTask

    dim oPump

    dim oStep

    dim colid

    dim tcnoid

    dim re

    set oPackage = DTSGlobalVariables.Parent

    set oPumpTask = oPackage.Tasks.Item("DTSTask_DTSDataPumpTask_2")set oPump = oPumpTask.CustomTask

    set oStep = oPackage.Steps.New

    When I run this task within the DTS package I get an error that says “task DTSTask_DTSDataPumpTask_2 was not found” . I have searched the web, asked co-workers and gone back to the original place where this was developed and no one seems to know how to fix this error. I just cannot find how to enter a reference to “DTSTask_DTSDataPumpTask_2” or where to place a reference to “DTSTask_DTSDataPumpTask_2” so that it can be found by the code.

  • December 8, 2006 at 9:23 am

    #676961

    Hey,

    My guess is that the DTSTask_DTSDataPumpTask_2 no longer exists but that it got replaced with another datapump task with a different system assigned name.

    You can find the system assigned names of any particular Transform Data Task by

    right clicking on the transform task line

    select Workflow Properties

    select the Options tab

    You can see the system assigned name there.

    If at some point they deleted the transformation and recreated it, chances are it got a new name; which appear to use a one-up naming convention.

    Teague

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply