Percentage Sampling Transformation

Percentage sampling transformation is used to split the dataset into separate outputs based on the percent and send it to different transformations for processing the dataset. This task is specifically used for data mining; we can divide the data and send it across as per our requirement

Percentage Sampling – If I take 10 as value than 10% of 1000 i.e. 100 records will be the output.

Step 1:

Click Windows button and go to SQL Server 2008 R2 and run as a administrator.

It shows a bellow window.

Step 2:

Go to a views and create a new project (Short cut of New Project is Ctrl + Shift + N).

Step 3:

Give a project name (e.g. IS) and click OK button and then shows a bellow window.

Step 4:

To drag and drop the Data Flow Task

Step 5: 

To edit the Data Flow Task then it open a Data Flow

Stem 6:

To drag and drop the OLEDB source and edit it

Step 7:

To give a OLEDB connection and select the table from given data base and select which columns are required.

Step 8:

Now drag and drop Percentage Sampling transformation and connect OLE DB source output as input to this transformation as shown below.

Step 9:

Now edit the Percentage sampling transformation and select PERCENTAGE of rows out of total records in the Source table you wants to use as sample by mentioning it “Percentage of rows”.

Step 10:

These are all the properties we can set for Percentage Sampling transformation. Now let’s create couple of destinations to store sampled output and not sampled output.

Step 11:

Take a data viewer to view the result report before execute.

Step 12:

Now the package is ready to execute and do the same. Make sure all the items turn GREEN.