Import non spatial data into SQL Server using ogr2ogr

Question

I am trying to import a CSV files in to SQL Server 2012 using ogr2ogr. The spatial data imports without any problems, but I cannot work out why the non spatial tables fail. I can import the data using other tools but it would be convenient if I could import everything using ogr2ogr so I can script it more easily.

My VRT file looks like this...

 <OGRVRTDataSource>
 <OGRVRTLayer name="test">
 <SrcDataSource relativeToVRT="1">test.csv</SrcDataSource>
 <FID>id</FID>
 <Field name="id" src="Id" type="Integer" />
 <Field name="Test" src="Attrib" type="string" width="100" />
 </OGRVRTLayer>
 </OGRVRTDataSource>

And my command line:-

 ogr2ogr -append -f MSSQLSpatial "MSSQL:server=SQL01;database=TESTDB;trusted_connection=yes" test.vrt

The first error I get is:-

ERROR 1: Column ogr_geometry requested for geometry, but it does not exist.

After that there are errors trying to create the attribute field because the table does not exist. If I manually create the table in SQL Server with a single field named "id", then this command works (still with error messages).

Answer 1

The solution was to upgrade the GDAL core libraries. Lesson learned!