DSXchange

I tried that, however the Latitude and Longitude values needed to update this value are on the record being updated/inserted as well. However, I did find a solution to this. Looking at the SQL, it's creating a string so I tested just doing an update/insert to this value using the string in hopes tha...

I am building a datastage job to populate a SQL Server 2008 target DB and the table has a Geography data type for a geospatial value from the latitude / longitude fields. I'm trying to figure out how to write the upsert statement to calculate and store the value. Below is the SQL statement if I were...