DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Average: 3 (2 votes)


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.


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.


Depends on COZYROC Script Component Plus 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