I know I shouldn’t be looking at these things before coffee. Still, when a SQL Import task complained about my Geometry column type, I tried to fix this.
I editted my “C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML” file, duplicating the entry for varbinary(max), but changing the data type name to “geometry.”
Bingo. Everything now seems to copy fine.
