ssis

Posts in this category.

SSIS: Auto-Rebuilding SSIS Script Tasks/SSIS Components to Sync Stale References

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: '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: Get best Threads and Rows Count

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