Select to view content in your preferred language

Load data in existing Geodatabase table using Sql Server

2682
2
05-07-2010 09:27 AM
MARIASALAZAR
Emerging Contributor
How do I load sql table data into an existing Geodatabase table using sql server?  I keep getting an error with the ObjectID.
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
What error are you receiving?

Is the objectid column the SDE-set registered rowid for the table?

How did you attempt to populate the new row(s)?

- V
0 Kudos
MARIASALAZAR
Emerging Contributor
I created a Visio UML Geodatabase - Imported the schema in ArcCatalog and I am trying to load the GDB Tables using Sql Server from scripts that I wrote.  The INSERT INTO GDBtable script gives me an error - Cannot insert the value NULL into column 'OBJECTID' ...

If I change the column property 'Identity Specification' - (Is Identity) to 'Yes'.  I can run the script successfully and load data but when I try to edit the table in ArcMap, it will crash.  If I open the attribute table during an edit session and then close table without editing an error message appears:  Loading Data Table - Could not load data from source.  If you correct the problem, press the refresh button to reload data.  Possible problems can include bad network connection, invalid field, ect.  There is no geometric network.  There must be a geometric network to preform this action.
0 Kudos