ssis

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply