From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Rowset transformations

Rowset transformations - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Rowset transformations

“

- [Narrator] Row set transformations can sort, sample and aggregate records in an input source. Let's apply a couple to our workflow. First, I want to sort the employees into alphabetical order. You can find the sort transform at the bottom of the common category. And it's right there, I'll just click and drag one in. Then I'll bring in the input data. So I'll click on additional split and drag the blue arrow and drop it on top of that. For the output, we're going to work with the employees data. Then I'll double click on the sort to configure it. I'm going to sort based off of the preferred name column. So I'll place a check mark there and that'll add a line down below. For the sort type we have the option of either ascending or descending. I'll leave it in an alphabetical order with ascending. And then take a look at the sort order. If you needed additional level to your sort, you would just add more columns from the list above and the specify the sort order to apply it in the right…

Contents