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

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

Hi @YudhiHermawan-6499 ,
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
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
7 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh