I've got some shapefiles, and need to convert the shapes into an SQL Geometry type and insert them into a table in our database. We're using GeoKettle.
I can open the shapefile find and read values in from it into the table (such as a text field in the shapefile into a varchar in the table), but don't know the steps I need to translate the shape, which appears to be coming out of the shapefile as WKT, into a geometry.
Basically, whenever I execute, I get the error that it doesn't seem to be able to insert it. Which is understandable, as I say it seems to be coming out as WKT and trying to insert that into a geometry field. And I know the method to convert it to geometry in SQL (STGeomFromText) - I just essentially need to know how to add that in GeoKettle.