Sequence number Generation

Vino_joe84 · Post by **Vino_joe84** » Fri Apr 25, 2008 3:55 am

Hi,

We need to create a number sequentially.
For ex. today my job ends with 1000 then tomorrow if i run the job it should start 1001.

How to achieve this in DS?

Do we have any stage to implement this?

ArndW · Post by **ArndW** » Fri Apr 25, 2008 4:08 am

At version 8 you can now generate such sequential numbers directly in the Transform stage. Look into the details tab "Surrogate Key" of the transform stage in the designer.

ramesh_inform · Post by **ramesh_inform** » Fri Apr 25, 2008 5:45 am

use surrogate key generator and parametrize the key value
pass the key value as parameter
run a script that takes the value