You configure the cache size in the transformation advanced properties. You can enter a numeric value in bytes, or you can select

Auto

to have the Data Integration Service determine the cache size at run time.

If you enter a numeric value, the Data Integration Service divides the cache size across the number of transformation threads at run time. For example, you configure the transformation cache size to be 2,000,000 bytes. The Data Integration Service uses four threads to run the transformation. The service divides the cache size value so that each thread uses a maximum of 500,000 bytes for the cache size.

If you select

Auto

, the Data Integration Service determines the cache size for the transformation at run time. The service then divides the cache size across the number of transformation threads.