TransWikia.com

GDAL OGR2OGR from gdbtable file to SQL Server table

Geographic Information Systems Asked by DJs on September 28, 2020

There is an existing SSIS package that loads a gdbtable file into SQL server table using ogr2ogr.
Command used is below

--config SHAPE_ENCODING "ISO-8859-1" -append -update -f MSSQLSPATIAL "MSSQL:server=Server1;database=DB1;trusted_connection=yes" "C:a0000000e.gdbtable" -nln dbo.table2 -gt 100000

With the above command the table2 in DB1 was populated fine before. It populated a ogr_geometry column of type GEOMETRY also fine.

But recently, when the above is run the GEOMETRY column ogr_geometry is populated as NULL.
It also gives an error "ERROR 1: Column O_SHAPE requested for geometry, but it does not exist.".
When I tried creating a dummy table in another DB in same server, say DB2 the geometry column is populated as expected and no error is raised.

Not sure what should I check in the DB1 to see if something has changed recently on the DB1? can someone help?

Thanks in Advance!

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP