Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export SQL 2008 data to KML or XML Format

Author  Topic 

jamesrah
Starting Member

13 Posts

Posted - 2010-04-09 : 09:18:13
Hi,

I have data in SQL 2008 and I need to export this data into KML format to upload into Google earth pro each time the SQL 2008 Data is refreshed. I have the following field in SQL 2008:

Name, Customer, Address, Job Number, Description, Job Status, Job Date Time, Latitude, Longitude, Latitude(DMS), Longitude(DMS), Latitude(SatNav), Longitude(SatNav), Altitude(m) & Job GPS Date Time.

Is there any way I can do this? Or does it need to be expored as an XML file format?

Any help is much appreciated.

Cheers,
James
   

- Advertisement -