kingswaysoft

Posts in this category.

Dataverse: Retrieve unmasked data (Masking Rule Column) via KingswaySoft

Mar 21, 2026

New day, new experience to discover! This time, I have a requirement to create an SSIS batch job function. During data retrieval, I found that the column is masked using the Masking Rule. This blog post is a brief note on how to retrieve the unmasked data. Enjoy! Dataverse Column...

Dataverse: Get best Threads and Rows Count

Feb 1, 2026

To know the best settings for pushing data to Dataverse is tedious work (for batch processing). We need to consider the client hardware (Logical processor - to support multithreading and ram capacity), Network, and also it is unique for each of the tables that you want to run...

Debunking: Dynamics CRM Destination - How Text Lookup Works

May 25, 2025

When we want to push data to Dataverse/Dynamics CRM using SSIS - KingswaySoft, usually there are relationships (lookup) that we need to settle. In KingswaySoft, there are multiple ways to handle the Lookup: Do not use TextLookup (Input values are provided in GUID Format) Use...