SSIS ShapeFileSource imports ESRI Shapefiles, and the associated attribute file (.dbf). The component based on the free Shapefile C Library.
Current version 1.0 beta can import ShapeFiles with Point, Linestring, Polygon and Multipolygon as SqlGeometry.
The version has been tested with several country level spatial data from
NUTS (Eurostats Administrative/Statistical Units)
The current version runs only under x86. When you work on x64 set Run64BitRuntime
in the project properties.
An exception will occur if the filename of the dbase file does not follow 8.3 naming conventions.
In my blog are some links to free ESRI shapefiles:
It's not possible to save geometry/geography data direct to the sql server with ssis in the moment. In my demo I use a script task to save the shapefile into the sql server.
To insert the spatial data, it must transform from DT_IMAGE to a string. Than you can insert data with
When you are looking for more SSIS Tasks please visit my german blog