Script Geocode Transformation
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.
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.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.