AnsweredAssumed Answered

ArcGIS assumes a not nullable number field from another database is ObjectID and ignores it

Question asked by blake.terhune on Nov 4, 2016
Latest reply on Nov 4, 2016 by blake.terhune

I'm using an OLE DB connection to connect to another database (SQL Server) that has nothing to do with ArcGIS. The tables there all have a numeric key field that is not nullable. When I try to use ArcGIS Desktop (10.2.2) to copy the data it just assumes it's an ObjectID field and ignores it. How can I tell a geoprocessing tool that a field is not ObjectID or force it to include it?

Outcomes