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.