Set the maximum length on string ports accurately. Do not set values that far exceed the physical size of the data that the ports will carry.

Configure your input ports to be the same type as the corresponding output ports. For example, cast numbers to numbers and strings to strings. Casting from one type to another when not necessary will have a performance impact.

Ensure that the Tracing Level in all transformations is set to Normal, as performance is degraded when set to a more verbose options.