No Sum Function Available in Aggregate in SSIS


  • I have no option in operation except Group by, Count, and Count Distinct, in all the examples I see and in the documentation I see they have a Sum Operation available. I tried selecting every column, not sure how to get the Sum operation
    Friday, March 23, 2012 6:20 PM


  • It is datatype driven.

    If you specify a numeric column, it will appear. I guess since you operate on a alphanumeric columns this operation naturally is nor supported.

    Arthur My Blog

    • Proposed as answer by Eileen Zhao Monday, March 26, 2012 8:53 AM
    • Marked as answer by Eileen Zhao Thursday, March 29, 2012 2:23 AM
    Friday, March 23, 2012 6:36 PM

All replies