Examining the Rowset transformations

- Now let's take a look at the rowset operations…that we have available to us in Integration Services.…The difference between a row operation…and a row set operation is a row operation,…that we looked at in the previous video,…just operates on a single row.…A row set operation operates on the entire rowset…that we retrieved.…So the first thing we're going to take a look at…is Aggregate.…And what we have is just a source.…And we're coming into Adventure Works…Data Warehouse 2014, and I'm issuing this SQL command.…

I'm gonna Tab on over to SQL Server Management Studio.…Where I have pasted in the command right here.…By the way, you see I've selected Adventure Works DW,…let me know you that if you're not familiar.…If I select it, you see everything turned red?…So I wanna select the right database.…I could also just put a use statement right up here.…Use whatever database I was going to work with.…And then SQL would know what to do,…but if I do that, I couldn't copy and paste.…

So we've got this, and we'll execute the query.…