tips
Posts in this category.
Jun 6, 2026
You created an SSIS package. Maybe some of the flows need Script Components/Script Tasks. You add those, write the necessary C# code, and verify it on your local system. All good, and you're ready to push it to the SSIS server where you want to run it via SQL Agent (to test N-N). You deploy the project and run the package on the server. Suddenly, you encountered the "SSIS: 'The binary code for the script is not found..'" error. Why is there a discrepancy when running the package locally versus on the server? Today, we will learn what the root cause is and how to prevent such things from happening.
May 24, 2026
When working with Power Platform, the Dev environment often holds the latest version of what your team is building. However, tracking what actually changed between exports across components, flows, and configurations is a tedious task. The diffs are noisy, the XML is unreadable,...
May 3, 2026
Today, we will learn how the Optional Setting features in KingswaySoft translate into HTTP Request-Response (with the help of Fiddler). The purpose of this document is to describe system behavior, to prevent performance degradation, and to support effective feature utilization....
Apr 19, 2026
The preview feature of Dataverse AI Prompt Columns enables us to tie specific Dataverse columns and add generative AI capabilities to be used in Apps, Workflows, or Reports. For example, we can add sentiment analysis to a specific column of the Case table/entity, or you can also...
Apr 5, 2026
New day, new things to learn. While integrating with Dataverse may seem straightforward at first, especially when it comes to DateTime things, it can quickly become complex due to different configuration settings. In this post, I’ll walk through the key factors that cause these...
Mar 15, 2026
Another blog post to handle the concurrency issue. Previously, I shared how to do concurrency via a plugin in this blog post and also how to force concurrency behavior in Dataverse in this post. However, when I attempted to implement this, it still did not resolve the concurrency...
Feb 21, 2026
Sometimes, we need to let the user see only the records under their care (dynamically connected via relationships). For example, we have the Region table > User and Order will be linked to the Region. Hence, the user will only see all the Order records that belong to the same...
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...
Jan 16, 2026
Happy New Year, everyone! Today, I want to share a list of knowledge that I have gained since I started learning SSIS - KingswaySoft! Certainly, the tips I wrote here may not be applicable/outdated later on, and you can call them out or discuss with me if you think I have a wrong...
Nov 29, 2025
I read Mark Carrington's blog post about his latest findings on TDS Endpoint revisited, which can be found here. One of the key points that is interesting is his finding about the internal Dataverse message ExecutePowerBISql, which intersects with the function I created last time...