Aggragate transform with "WHERE" condition

Hello, I am new in SSIS.

I have to Load a table with aggregate data, I can do it using Aggragate transformation, but other the "GROUP BY" I need to make a filter on input records with "WHERE" condition.

In TSQL it should be:

SELECT col1, SUM(col2) FROM T

GROUP BY col1

WHERE col3 = value.

But in SSIS ?

How can I do it?

Thank

If it is in the Where clause and not Having, I would just place the Where in the Data Source that feeds into the Aggregate Transformation.|||

I need more details... I dont know if I understood...

You can add the where condition in your SQL statment in the datasource, or you can use the ConditionSplit transform to filter the data... you more other options...

give more details...

helped?

regards

|||Use a conditional split before the aggregation to filter your data.|||

csi_hugh wrote:

If it is in the Where clause and not Having, I would just place the Where in the Data Source that feeds into the Aggregate Transformation.

So would I. If you have the option to, always filter the data at source rather than use a Conditional Split.

-Jamie