Unfortunately there is no built-in support in SSIS for spatial data.

You will have to implement it yourself.

The following articles might be helpful:

http://www.sql-server-performance.com/articles/biz/spatial_data_support_ssis_p1.aspx

http://msdn.microsoft.com/en-us/magazine/dd434647.aspx