SSIS – Script Task to obtain Geo-Cordinates from Address Text via Google API

Hi, This post is about a quick solution to a problem which I have come across quite few times. In few instances, I was required to obtain the “Latitude” and “Longitude” coordinates of the address stored as strings/text in the columns of the database. This was primarily required to leverage the mapping features of the Read More …

Remote SSIS Execution, Windows Service Application

Hi, Recently stumbling upon the SSIS double hop authentication issue and figuring it out (after a lot of head scratching). The solution I adopted to over come the issue is posted out as follows: Loading and Running a Remote Package Programmatically (MSDN) – What is Double Hop Authentication Issue with SSIS ? This article can Read More …