Post reply

No summing of agregate task?

  • September 2, 2008 at 3:28 pm

    #154685

    Hi all,

    I have a data flow task which contains a OLEDB source, aggregate, and flat file (fixed width)destination objects. Basically I'm just trying to count some of the columns and sum a few of the columns. The plan is use these in a footer row which will be different from the the fixed width detail.

    I was thinking that the aggregate transformation task would be perfect. Unfortunately, it only has group by, count, and count distinct (I was looking for more agregate functions sum, countif, etc.). So it looks like I'll be able to count a particular column but there 's no summing of columns?

    Should I be looking at another task for suming columns or is the aggregate task only limited to group by, count, and count distinct?

    Thanks,

    Strick

  • September 3, 2008 at 10:23 am

    #866625

    Hey,

    There is a sum operation on the aggregate function, also a count distinct, mini and maxi.

    But careful, you would need the values to be sorted prior to performing the aggregation which may be costly.

    Trust this helps

    ~PD

  • September 3, 2008 at 10:50 am

    #866653

    Hi, that's really odd then. No sum shows up. Only Group By, Count, and Count Distinct show. Does sorting it make the sum show?

    Thanks,

    Strick

  • September 3, 2008 at 11:25 am

    #866672

    For DT_STR type data types you will get count and count distinct becoz thats the only aggregations possible. Sum, Avg, Min, Max will only be available for number datat types.

  • September 3, 2008 at 11:33 am

    #866674

    Sweet, thanks!! That's exactly what it was! I'll have to use a data conversion task to convert some of the columns to from string to numeric since they are coming in as strings.

    Thanks,

    Strick

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply