How can I load data into SQL Server spatial using SQL Server Integration Services (SSIS)?

I'm aware of other tools, like FME and ogr2ogr, but my only option is using SSIS

  • 1
    Please edit the question to specify what SSIS is. Since it's your "only option" you should probably state what you have tried and what you have had trouble doing. – Vince Jun 28 '16 at 12:09
  • What is the source of your data? – DPSSpatial Jun 28 '16 at 14:30
  • @DPSSpatial variety of sources, ranging from CSV, xlsx, web service, Oracle db, MapInfo tab. I'm fine with using SSIS to read the data, but can find any "easy" way to handle the insertion into the SQL Server geometry – SteveC Jun 28 '16 at 14:52
  • If SSIS can read those sources, the next task is to figure out if you can cast the geometry from those sources to TEXT, ie. VARCHAR, etc. From there, simply inserting the VARCHAR geometry into an actual geometry table works for our BI team (reading from SQL Server), and I use this method in Python to read/write PostGIS to MSSQL Spatial... if you want more details I can provide them... – DPSSpatial Jun 28 '16 at 14:58
  • 1
    @SteveC let me see if I can get an SSIS file from our BI folks... – DPSSpatial Jun 28 '16 at 15:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.