title: set sequence number for group of data
body: <p>I want to simulate a sequence number for a set of record in SSIS. the challenge is running sequence number start with 1 and increment by 1 for each POLNO,RNWNO,ENDNO,RISKNO combination. I know how to create continuous sequence but I don't know how to depend on it to these for parameter in ssis. my source is Oracle and I am moving data by SSIS to another Oracle database. please help me. </p>
  
  <p>wise 
  Example</p>
  
  <pre><code>Polno   Ren   End  Risk   ID Number   Seqno
  p1          0      0        1        ID01               1
  p1          0      0        1        ID02               2
  p1          0      0        1        ID03               3
  p1          0      0        2        ID04               1
  p1          0      0        2        ID05               2
  p1          0      0        2        ID06               3
  p1          0      1        1        ID01               1
  p1          0      1        1        ID02               2
  p1          0      1        1        ID03               3
  p1          0      1        2        ID04               1
  p1          0      1        2        ID05               2
  p1          0      1        2        ID06               3
  </code></pre>