May 3, 2015 at 11:47 am
Working within SQL Server 2014 the old standby of shape2sql doesn't seem to be working. I even tried the trick of copying the DLL and renaming it. Still no joy.
So, I'm looking for alternatives. I need the alternatives to be free or near free, simple and easy to recommend to others. I'm checking out ogr2ogr currently. I'm looking for other suggestions. How else have you dealt with this type of data?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2015 at 12:21 pm
shape2sql only works up to 2008R2, didn't get to work properly for 2012 so I had to do few tricks;-)
First one was pretty lame, import to 2008, detach and attach to 2012/2014, worked like a charm though. Have some more advanced things in the trick bag, which files are you trying to import, can look if I have anything that fits.
😎
May 3, 2015 at 5:27 pm
While I don't have any direct experience with this (I have other tools FME by Safe Software), the following links may help.
https://shapefilesource.codeplex.com/ - For a SSIS shapefile reader
http://blog.strictly-software.com/2011/11/error-copying-tables-importing-or.html - For enabling SSIS to use geometries and geographies.
May 4, 2015 at 4:05 pm
Thanks for the input guys. I guess I'll make this ogr2ogr work. It's kludgy in the extreme, but seems functional.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply