question

YudhiHermawan-6499 avatar image
0 Votes"
YudhiHermawan-6499 asked ZoeHui-MSFT commented

Operation on Aggregation component not complete

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
image.png (7.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


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. :)

0 Votes 0 ·