Script Geocode Transformation

Overview

Data flow transformation which loads from Google Geocoding service the latitude and longitude coordinates for data flow input address. The script can cache already loaded coordinates locally for future use. Please keep in mind Google Terms of Service License Restrictions.

Setup

The script has the following parameters:

• AddressColumn - Address input column.
• ApiKeyVariable - Package variable containing Google Maps API key.
• CacheFile - file connection manager to coordinates cache file.