please help me this problem....
i have a source table with 17 fileds anda destination table with 18 fields. i have to insert all the rows into the destination reading from the source. i am using a transformaer to map all the fields between the source and destination. my problem is, the 18th field in my destination table which is not mapped to any filed in the source is the primary key for the destination table.
As expected when i try to insert into the destination it gives me an error saying cannot insert a null value to the primary key.
Is there any function/way in which i can specify a one up/ MAX +1 value for this field in DS ?????
![Sad :(](./images/smilies/icon_sad.gif)