Create Auto-ID Field

[TroyNagle]

Is there a way to create a field and have it auto populate with ID numbers using Data Interop ?

[BruceHarold]

Hi Troy

This will be workspace dependent.  For example in SQL Server 2008 you could have a field of type UniqueIdentifier and create values with the UUIDGenerator in your workbench.  Data Interop will populate the uniqueidentifier field.

You can mimic this behavior with integers you make unique using a Counter transformer, it depends on the quality of result you are looking for.

Regards