Geocode Transformation

Your rating: None Average: 3 (3 votes)

Overview

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.

Requirements

Depends on COZYROC Script Component Plus component for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.Web

ScriptMain