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!
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP