Experiments, tutorials and ideas on developing business intelligence solutions
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 …
Hi, This is a quick post, to illustrate about a challenge where I had to manage M2M relationship in MDS 2014. Well this issue has been taken care off in MDS 2016 version which you can read about in the post. But if you are stuck in the 2014 MSSQL world and wanted a reliable Read More …
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 …