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;

Finding object ID

Download Free Trial Learn More About Our ETL Software