>I have a package to migrate VFP data to SQL Server. This works pretty much ok so far. All my tables have an auto incremental field. However, once the package is run, the auto incremental field is migrated as Integer. This does not seem to be recognized. What should I do to preserve that field?

You can use an Identity field. BUT IMHO using an integer field as PK is not a good idea (I'm in use GUID as PK camp).
Cetin