Another useful suggestion from our users was implemented in the latest version of Visual Importer ETL:
Suggestion:
I have a large Case object within a package running separate
transformations based on a variable. It's calling 30+ transformations
and that approach is becoming unwieldy.
To simplify, it would be good to replace the Case with a script object
containing code that runs a transformation based on a variable?
Note:
This function was implemented in 3 days.
From the documentation:
ExecuteObject(ObjectId)
Call ExecuteObject to execute Transformation, Sql Script or Package. Returns 0 on success and 1 on error
begin
result:=executeobject(4196)=0;
end;
Download Free Trial | Learn More About Our ETL Software |