Post reply

Based on Global Variable parameter execute different Data Pumps

  • October 22, 2004 at 7:54 am

    #162495

    My Transformation depends on Global Variable.

    How do I construct a workflow?

    Here is the logic:

    IF gv_configCOBDate = '000-00-00' THEN 

        do transformation1 (parameter1)

    ELSE

        do transformation2 (parameter1,parameter2)

    END IF

     

  • October 22, 2004 at 8:06 am

    #527656

    Why not dynamically change the datapump parameters/settings based on the global variable?  This way you don't have multiple branches but 1 dynamic properties set.



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • October 22, 2004 at 1:53 pm

    #527712

    IF gv_configCOBDate = '000-00-00' THEN 

        DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataPumpTask_1").ExecutionStatus = DTSStepExecStat_Waiting

    ELSE

     DTSGlobalVariables.Parent.Steps("DTSStep_DTSDataPumpTask_2").ExecutionStatus =   DTSStepExecStat_Waiting

    END IF

     

     

    [font="Courier New"]ZenDada[/font]

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

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