Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area



Buy Now Free Trial Download Compare Editions More Features

Task Factory Advanced Aggregator Transform

Our Advanced Aggregator Transform takes aggregation in SSIS to the next level. We extended the base functionality of aggregate functions to allow expression based aggregation and added a few more aggregation functions (First, Last) into the equation. So now you can use something like SUM(Quantity, UnitPrice > 20) which will only sum the quantity if the price is greater than 20.

Feature Highlights

  • Advanced aggregate functions allow for conditional inclusion.
  • First and Last aggregate functions are available.
Advanced Aggregator Transform

Advanced Aggregator Transform- Step 1
The configuration editor of the Advanced Aggregator Transform is similar to an expression editor. Users can access all of the variables & columns in one window, and functions & operators in another. Below that, aggregations can be added to selected columns.

The configuration editor of the Advanced Aggregator Transform is similar to an expression editor. Users can access all of the variables & columns in one window, and functions & operators in another. Below that, aggregations can be added to selected columns.

Advanced Aggregator Transform- Step 2
To configure the transform, add a column name if you are choosing to create a new column for the aggregation.

To configure the transform, add a column name if you are choosing to create a new column for the aggregation.

Advanced Aggregator Transform- Step 3
Next, expand the aggregation folder in the list of functions.

Next, expand the aggregation folder in the list of functions.

Advanced Aggregator Transform- Step 4
Drag the aggregation to the expression field followed by the column on which to perform the aggregation.

Drag the aggregation to the expression field followed by the column on which to perform the aggregation.

Advanced Aggregator Transform- Step 5
Select the data type and specify a length, if needed. At the bottom of the editor, click ‘Validate All’ in order to verify that the expressions have been written correctly.

Select the data type and specify a length, if needed. At the bottom of the editor, click ‘Validate All’ in order to verify that the expressions have been written correctly.

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works