April 7, 2011 at 3:57 pm
Hi All,
Can you please help me to perform the automation of .shp file upload to SQL tables (SQL Server 2008).
My file has customer info and longitude & latitude information.
I tried to find find solution online, but failed.
Solution I tried - download shape2sql tool and tried to upload but it wasn't working for me. it is not giving me an error but, I don't see the data uploaded.
Please suggest.
Thanks,
Swetha K
April 7, 2011 at 10:33 pm
What are you seeing? What kind of observations can you share with us?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 8, 2011 at 2:13 pm
I have selected the file which needs to be uploaded but it doesnt show me the column names and doesnt import any data though hit upload button.
I should also be able to automate the process of upload. Please suggest.
April 8, 2011 at 2:17 pm
How exactly are you trying to upload the file currently?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 8, 2011 at 4:03 pm
used shape2sql tool. Running shape2sql.exe I selected the file needed to upload, configured the server and table which is used for inserting records, checked create spatial index and planar geometry.
and hit "upload to database" button.
which is not giving me any results.
Swetha K
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply