The most basic use is to calculate the distance from A to B. This is what we will look at using SSIS. The API takes in an origin and a destination. These can either be a lat & lng combo or an address which we be translated into Lat & lng when executed. To demonstrate the process I have created a database and loaded it with some sample customer and store data. We have 2 customers and 4 stores. These customers are linked to different stores. You can download the example files at the bottom of the page.
I like that this shows just how easy it is to hit an API with an SSIS component. If I had one wish with this article, I’d use Biml to generate the package rather than talking through the tasks and components. Regardless, check this out; it’s a great use of the script component.