When you need to import hundreds of thousands records, it can take a long time to import with the KingswaySoft destination. This can be a serious issue, if a large data load is part of a scheduled running job. For this reason, it can make a lot of sense, to balance the load across multiple […]
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.
This is just a quick post for, with a old method for fetching the row count for a entire database – for future reference (Works in Azure – doesn’t require stored proc)
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 […]
It can sometimes be a requirement, to open a dashboard in a seperat window using a URL – but what does the link look like, and where can you find the info you need? The URL is a static one, where you only need to replace the GUID for the given dashboard, you wish to […]