Posts in this category.
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.
Feb 22, 2025
Last week, we learned how to create an email notification to remind us if App Registration in Azure expires. Today, we will learn how to apply automation to generate a New Secret and update the Dataverse Environment Variable. In the flowchart, here are the steps that we will do:...
Aug 17, 2024
Based on part 1 which you can read here, I realized that creating a plugin to automate the approval process will be easier compared to creating Power Automate Flow. The main reason is, that if we need to use Flow, then we need to create multiple connection reference components...
Jun 2, 2023
We can use tons of remarkable commands in Power Platform CLI that can be very useful. For example, when changing Localization. Instead of doing it in the usual way which needs to change the Personalization Settings > Languages > Base Language: Then we need to go to the component...
Feb 5, 2023
Last week, we already learn how to build Angular WebResources to be shown in the side pane. In that blog post, I deploy all the files manually which of course took time to do. Today, we will learn how to optimize it in order to boost productivity. We will learn how to use spkl...
Dec 17, 2022
Last week, we already learn how to set up Azure DevOps Pipeline for Web Resources. And this week, we will learn how to set up the pipeline, but for the Plugin (backend customization). And the interesting part, we also will implement the Plugin Package (or plugin-dependent...
Dec 10, 2022
Before we begin, this topic is similar to what Benedikt Bergmann explains in his blog post. But like always, if I do not yet try it by myself = I do not yet fully understand 😀. The twist will be I will create the web resource project using Dataverse DevTools by Danish Naglekar...
Dec 3, 2022
When I published this blog post about Power Automate Deployment (manual), the great - Bill Blancett gave suggestions regarding the solution's import setting file that we can use if we want to import the solution using CI/CD or using Power Platform Tools CLI (you need to make sure...