When I work with contracts, accruals, forecasts etc, I often have to calculate the duration of the contract, or in general the difference between two dates. I have been using an ordinary datediff in Months, as this is the fastest way, to get the duration of a contract in months.
When using multifactor authentication for your Dynamics 365, it tends to cause issues with the KingswaySoft connector, as MFA is not supported by their toolkit. Therefore – as an alternative to disabling the MFA – you can switch to OAuth authentication in the KingswaySoft connection manager and connect with a Azure Application user, and I […]
For this small how-to, I’ll go through how to use the Merge Join in SSIS. The Merge Join is used for joining data into the a single row from two different datastreams. A basic example, where the MergeJoin can be used, is where you have a flat file with emails, and you need to locate […]
I have previously writting about an error I recieved when I attempted to installed SSDT for Visual Studio 2017. But with the new version of SSDT, Microsoft have seemingly fixed the bug, and you can now easily install SSDT with Visual Studio 2017. Firstly, you need the installer for Visual Studio 2017 (community works fine) […]
This is something I find myself doing over and over and over again, when importing data to CRM, seeing as CRM wants the contacts as Firstname and Lastname. And the data I receive is very rarely in that condition. So I find myself having to split the column fairly often – and I always forget […]
