If you have longer T-SQL script with several selects, the SSIS pickups the first select which produces "a resultset". Usually, the last select is used to produce the final result....

Please see my comments in brackets.

From what I can gather, for each entry in t, you want to have a result of t.id, and the minimum t.id where t.col =...

Yes, the mapping need to be stored in table.

Mapping Table:

Map_t_to_r

--------------------------

t_IDr_ID

1.......1

2.......2

3.......2

4.......2

5.......2

6.......2

7.......2

8.......8

(Sorry I used dots instead spaces to distinguish columns. Trailing spaces or tabs don't work in this form)

I wanted to use...

Please see my initial post:

source: table t

target: table r

operation:

insert r (id, col)

SELECT

MIN(id) AS id,

col

from t

...

Thanks SSCrazy, this is good idea. But the point is that I have one big insert where is the aggregation and group by.

I have to get that mapping into...