Evaluating expressions programmatically -
06-06-2006
, 12:26 PM
All -
I would like to create a custom transformation component similar to
"DerivedColumn" transformation that would allow to specify expressions as
input.
When the component's "ProcessInput" is called i would like to use the
expression the user specified - evaluate it - and do some custom action based
on that.
I presume that IDTSCustomProperty allows to specify an expression - but
where can we get the evaluation results of it / how to evaluate the
expression.
Lets say the expression is Column1 > Column2 - how do we provide the inputs
for Column1 and Column2 (where column1 and 2 are not variables but a field
name of a table)?
There is a ExpressionEvaluatorClass that seems to be undoced.
Please provide ur suggestions.
Regardz
Grafix. |