• While I don't have any direct experience with this (I have other tools FME by Safe Software), the following links may help.

    https://shapefilesource.codeplex.com/ - For a SSIS shapefile reader

    http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html - For enabling SSIS to use geometries and geographies.