The Data Integration Services creates a default partition type at each partition point. If you have the Partitioning option, you can change the partition type. The partition type controls how the Data Integration Service distributes data among partitions at partition points.
When you configure the partitioning information for a pipeline, you must define a partition type at each partition point in the pipeline. The partition type determines how the Data Integration Service redistributes data across partition points.
You can define the following partition types:
Dynamic Partitioning
When you use dynamic partitioning, you can configure the partition information so that the Data Integration Service determines the number of partitions to create at run time.
Key Range Partitioning
You specify one or more ports to form a compound partition key. The Data Integration Service passes data to each partition depending on the ranges you specify for each port. Use key range partitioning where the sources or targets in the pipeline are partitioned by key range.