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.
Options
- 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.
See Also
Other Resources
Integration Services Error and Message Reference
Percentage Sampling Transformation