SSIS Script Task "No binary code" help
Good morning all,
For a couple of months now, I've been having this issue. I think it's related to .NET, but I can't be sure.
The error I see in our SSIS Script Tasks (using VB) is:
>The binary code for script is not found.
It advises opening the Script and clicking on "Build" to ensure the script can be compiled successfully, and this is successful, but the moment I close the VSTA editor and click "Ok", it tells me there are compilation errors. As a test to keep things simple, this is the script I'm using:
Public Sub Main()
MsgBox("Hello world")
Dts.TaskResult = ScriptResults.Success
End Sub
We are using Visual Studio 2019 Pro. This is for a test project targeting SQL Server 2022, but it happens for Projects targeting SQL Server 2019, SQL Server 2017 and SQL Server 2016. In this test project, the VB version is 2019.
I have tried
- Reinstalling Visual Studio, including jumping to Visual Studio Pro 2026.
- Reinstalling SSISP
- Reinstalling VSTA 2019
- Repairing .NET Framework versions (4.5.x primarily)
Some of the online resources mention this is an issue with incorrect References or migrating from an older Target Server, but this test project started with SQL Server 2022 as the target, and I don't believe the references can be the issue with this test script.
I'm perplexed at this issue, and hoping someone may have experienced a similar issue and has a solution