Post reply

Aggragate transform with "WHERE" condition

  • August 31, 2007 at 7:06 pm

    #118342

    Hello,

    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

  • September 2, 2007 at 11:05 pm

    #730959

    Pretty much the same way assuming you're using an OleDB data source, you can then specify the query to run.  Be sure to include column names for all of your columns in your select statement (e.g. sum(col2) as total).

    Joe

     

Viewing 2 posts - 1 through 1 (of 1 total)

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