#c#
Posts tagged with this topic.
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.
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 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...
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...
Oct 11, 2025
Hi Everyone, I'm back, and today, we will learn how to implement translating addresses to longitude and latitude (using Azure Maps API) and validating check-ins. For example, there will be a plan for the Salesperson to go to location X for Customer A. On the day itself, the...
Aug 2, 2025
I'm fairly certain that all of us agree that we are performing mundane code to obtain input parameters when developing custom APIs. For populating the context.PluginExecutionContext.InputParameters, we need to extract each parameter and cast the value to the correct data type,...
Jul 20, 2025
Azure Durable Functions is an extension of Azure Functions that offers specialized capabilities, including statefulness, orchestration, handling retries, and support for running long-running operations. The orchestration functions can help us group multiple processes and bundle...
Jun 14, 2025
With the hype of Model Context Protocol - it's kinda a plugin for LLM (Large Language Model) to interact with the external tool(s), I always wonder how to create one. For my field, which is Power Platform - Dataverse, I saw the great Natraj's GitHub repo about MCP Dataverse, and...
Jun 1, 2025
As a (lazy) Developer, I always find a way to implement something as simply as possible. The more experience that we are gaining over the years will eventually show us certain language features/components that can support it. For example, in today's blog post, we want to create a...