SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Integration Services
Technical Reference
Feature Reference
Integration Services F1 Help
SSIS Designer F1 Help
Transformation Properties UI Reference
Advanced Editor (Connection Managers Tab)
Advanced Editor (Component Properties Tab)
Advanced Editor (Column Mappings Tab)
Advanced Editor (Input Columns Tab)
Advanced Editor (Input and Output Properties Tab)
Aggregate Transformation Editor (Aggregations Tab)
Aggregate Transformation Editor (Advanced Tab)
Audit Transformation Editor
Cache Transformation Editor (Connection Manager Page)
Cache Transformation Editor (Mappings Page)
Character Map Transformation Editor
Configure Error Output
Conditional Split Transformation Editor
Copy Column Transformation Editor
Data Conversion Transformation Editor
Data Mining Query Transformation Editor (Mining Model Tab)
Data Mining Query Transformation Editor (Query Tab)
Derived Column Transformation Editor
Export Column Transformation Editor (Columns Page)
Export Column Transformation Editor (Error Output Page)
Fuzzy Grouping Transformation Editor (Connection Manager Tab)
Fuzzy Grouping Transformation Editor (Columns Tab)
Fuzzy Grouping Transformation Editor (Advanced Tab)
Fuzzy Lookup Transformation Editor (Reference Table Tab)
Fuzzy Lookup Transformation Editor (Columns Tab)
Create Relationships
Fuzzy Lookup Transformation Editor (Advanced Tab)
Lookup Transformation Editor (Connection Page)
Lookup Transformation Editor (Advanced Page)
Lookup Transformation Editor (Columns Page)
Lookup Transformation Editor (General Page)
Lookup Transformation Editor (Error Output Page)
Merge Transformation Editor
Merge Join Transformation Editor
Multicast Transformation Editor
Percentage Sampling Transformation Editor
Row Sampling Transformation Editor
Select Script Component Type
Script Transformation Editor (Input Columns Page)
Script Transformation Editor (Inputs and Outputs Page)
Script Transformation Editor (Script Page)
Script Transformation Editor (Connection Managers Page)
Sort Transformation Editor
Term Extraction Transformation Editor (Term Extraction Tab)
Term Extraction Transformation Editor (Exclusion Tab)
Term Extraction Transformation Editor (Advanced Tab)
Term Lookup Transformation Editor (Reference Table Tab)
Term Lookup Transformation Editor (Term Lookup Tab)
Term Lookup Transformation Editor (Advanced Tab)
Union All Transformation Editor
Unpivot Transformation Editor
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

Row Sampling Transformation Editor

SQL Server 2008 R2

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.