To optimize a mapping, identify a performance bottleneck, eliminate it, and then identify the next performance bottleneck. Optimize one mapping component at a time. You can time a mapping before and after the change to verify that the optimization has a performance impact.

You can find and fix bottlenecks in mapping components such as sources, targets, and connections. You can check bottlenecks in the Data Integration Service and the machine that the Data Integration Service runs on. You can also tune properties for web services and SQL data services.