Get N sample rows from a huge dataset

In my previous article I have discussed about Percentage Sampling Task. But, there is one one task similar to that in Integration Services. This task fetches only N sample rows from the given dataset.

Row Sampling Transformation

Row Sampling task can be used in a situation wherein you need only N random rows from the huge dataset. The special advantage is that, we can use random seed value for random row selection. Of course, we can do the sample with Percentage Sampling task.