DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
Overview
Data flow source 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.
Requirements
Depends on COZYROC Script Component Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.