Export (0) Print
Expand All
Expand Minimize

Row Sampling Transformation Editor

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

To learn more about the Row Sampling transformation, see Row Sampling Transformation.

Number of rows

Specify the number of rows from 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 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 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 as a seed 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