IEtlTask.ParamValues

Syntax

ParamValues: IMetabaseObjectParamValues;

Description

The ParamValues property returns the collection of ETL task parameter values.

Comments

The principle of parameters collection setup is identical to the principle of setup of other repository object parameters and is described in the Setting Up Objects Properties and Parameters subsection.

Example

Executing the example requires that the repository contains an ETL task with the ETL_TASK identifier. The task structure contains two created parameters with the FILTER_VALUE and ERROR identifiers.

Add links to the Etl, Metabase system assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Etl: IEtlTask;
    Params: IMetabaseObjectParamValues;
Begin
    Mb := MetabaseClass.Active;
    Etl := Mb.ItemById("ETL_TASK").Bind As IEtlTask;
    // Set parameter values
    Params := Etl.ParamValues;
    Params.FindById("FILTER_VALUE").Value := 1000;
    Params.FindById("ERROR").Value := 0.01;
    // Execute ETL task
    Etl.Execute(Null);
End Sub UserProc;

After executing the example, the ETL task is obtained, and values for task parameters are set. After this the task will be executed.