Share via

Operation on Aggregation component not complete

Yudhi Hermawan 1 Reputation point
2021-08-10T09:04:27.097+00:00

Hi all

i use SQL Server 2019 Integration Services, found Aggregation component only show 3 operation (Groupby, Count, CountDistinct).
i cannot see Sum, Min, Max or other aggregation operation

121934-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 Reputation points
    2021-08-11T01:21:57.89+00:00

    Hi @Yudhi Hermawan ,

    The issue is related with your data type.

    Sum: Only columns with numeric data types can be summed.

    Minimum: This operation can be used only with numeric, date, and time data types.

    Maximum: This operation can be used only with numeric, date, and time data types.

    Please refer: aggregate-transformation

    If you want to use these operation, please make sure the data type is correct.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October