SSIS Row Sampling Transformation

SSIS Row Sampling Transformation

Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks, between data source and destination components, or other transformations.

Sometimes the source data has large volumes, and during development, less rows would be better to keep the speed of the tests high. The Row Sampling transformation can be used for random sampling, to create a small but representative dataset. A fixed number of rows can be selected using Row Sampling, defined in the SamplingValue property - which can be overridden with SSIS Expressions.

If a percentage of the input rows should be selected by a transformation (instead of a fixed number), check the Percentage Sampling Transformation.

This transformation is a row (synchronous) transformation, and supports one input and two outputs: the sample output and the unselected output. It does not support an error output since data values on the outputs do not depend on any evaluation of expressions.

For more detailed information on this transformation, please refer to this MSDN article.
For the complete list of SSIS transformations, check this Wiki article.

Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Zoltán Horváth edited Revision 2. Comment: adding a use case example, minor formatting

  • Zoltán Horváth edited Original. Comment: adding content, correcting MSDN artcile link

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Zoltán Horváth edited Original. Comment: adding content, correcting MSDN artcile link

  • Zoltán Horváth edited Revision 2. Comment: adding a use case example, minor formatting

  • Zoltán Horváth edited Revision 3. Comment: added error output info and Percentage Sampling Transformation link

  • Zoltán Horváth edited Revision 4. Comment: added link to List of Transformations in the first paragraph

  • Statistics point of view must be added later...

  • Statistics point of view must be added later...

Page 1 of 1 (6 items)