Export (0) Print
Expand All
Expand Minimize

Percentage Sampling Transformation Editor

Use the Percentage Sampling Transformation Editor dialog box to split part of an input into a sample using a specified percentage of rows. This transformation divides the input into two separate outputs.

To learn more about the percentage sampling transformation, see Percentage Sampling Transformation.

Percentage of rows

Specify the percentage of rows in the input to use as a sample.

The value of this property can be specified by using a property expression.

Sample output name

Provide a unique name for the output that will include the sampled rows. The name provided will be displayed within the SSIS Designer.

Unselected output name

Provide a unique name for the output that will contain the rows excluded from the sampling. The name provided will be displayed within the SSIS Designer.

Use the following random seed

Specify the sampling seed for the random number generator that the transformation uses to create a sample. This is only recommended for development and testing. The transformation uses the Microsoft Windows tick count if a random seed is not specified.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft