Aggregate Transformation fails in Dynamic Data Flow Task+

[parag kalra]

Hi,

Aggregate Transformation fails in Dynamic Data Flow Task+ when sum operation is performed on a column with datatype NUMERIC or FLOAT. It only works with INT.

It fails with Below Error:

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Aggregate" (19) failed with error code 0x80070057 while processing input "Aggregate Input 1" (20). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.