dynamics-crm

Posts in this category.

SSIS: 'The binary code for the script is not found' - what it actually means

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.

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: How to set a Complex Query for System View

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...

Azure Function to scrape Yahoo data and store it in SharePoint

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...

What I learned about SSIS

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...