none
No Sum Function Available in Aggregate in SSIS

    Question

  • 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

Answers

  • 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
    Moderator

All replies

  • What is the data type on Column 7? I has to be a "Sum"-able column.

    Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008

    Friday, March 23, 2012 6:31 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
    Moderator
  • Thanks, that was it.
    Friday, March 23, 2012 8:44 PM
  • Please mark all the applicable replies as the answer.

    Thank you!


    Arthur My Blog

    Friday, March 23, 2012 9:02 PM
    Moderator