Latest posts
Notes on code and the things I build.
ssis
, Clean Code
, devops
Jun 21, 2026
Coming from a stronger C# background, I instinctively reach for helper classes to maintain DRY (Don't Repeat Yourself) principles. That instinct served me well until I carried it into SSIS. When I needed to reuse logic across packages, I did the natural thing: I built a shared DLL and registered it in the GAC on the server. It worked fine until I needed to add more optional arguments or change the data type of the argument to the existing method. Every time I need to update that assembly and re-import it, my packages break with a DTS Script Task: Runtime Error. The reason caught me off guard: the precompiled script binaries inside each package were still bound to the old version of the DLL, and a normal build never recompiles them. In today's post, I'll walk through how I tackled this by building a console application that rebuilds the Script Tasks and Script Components automatically.
ssis
, tips
, kingswaysoft
, dynamics-crm
, .NET
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.
AI
, Clean Code
, dynamics-crm
, low-code
, powerplatform
, tips
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,...
dynamics-crm
, kingswaysoft
, powerplatform
, tips
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....
AI
, dynamics-crm
, low-code
, powerplatform
, tips
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...
dynamics-crm
, tips
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...
.NET
, dynamics-crm
, kingswaysoft
, powerplatform
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...
.NET
, Architecture
, Azure
, C#
, Clean Code
, dynamics-crm
, tips
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...
dynamics-crm
, low-code
, powerplatform
, tips
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...
AI
, Architecture
, Azure
, Copilot Studio
, dynamics-crm
, low-code
, powerplatform
Feb 14, 2026
A couple of weeks ago, I learned about an AI Agent from this Microsoft DevBlogs, which mainly talks about building an AI Agent on top of Copilot Studio. So, as a good student, I tried to build my own Agent to learn about Indonesian Stocks. But, for this part, I just want to show...