ssis

• scheppalli

  Newbie

  Points: 4

  More actions

  May 16, 2013 at 10:24 pm

  #274023

  hi all,

  my excel source file contain some data name as coordinates i want to load it into sql server table the col data type is Geometry but it is not loading i think ssis does not support gemeotry data type how to load data into oledb destination is there any process in ssis

• Matthew Cushing

  SSCrazy

  Points: 2898

  More actions

  May 21, 2013 at 10:10 am

  #1617098

  SSIS doesn't support it, so the only way you'll really be able to get it in (I believe) is by using a script task.

  This thread might help http://www.sqlservercentral.com/Forums/Topic965972-391-1.aspx

  Also, you might just try importing it as varchar and manipulating it later in your app or webpage.