When adding new records, the auto-enter option of the Import script step starts from 1 without taking into account the ID's of the target table. Is it possible to control it?
For example, let's assume that:
My target table file contains 100 records with ID's ranging from 1 to 100.
My source table file contains 50 records with ID's ranging from 1 to 50.
After adding new records with the Import script step, I get a table can has both the records of the target and source table but:
The first 100 records, originally in the target table, have ID's ranging from 1 to 100.
And, the following added records, coming form the source table, have either their original ID's (if the auto-enter option is unchecked) or they are given IDs raging from 1 to 50 (if the auto-enter option is checked).
So, after importing the new records I get repeated ID's (1 to 50)
Would it be possible to have the first 100 records from the target table have their original ID's (ranging from 1 to 100) and the newly added 50 records having ID's franging from 101 to 150?
If the answer is yes, any ideas how to achieve this?