question

ElaenaBakman-4685 avatar image
0 Votes"
ElaenaBakman-4685 asked ·

Visual Studio 2019, SSIS Script Task Error: The binary code for the script is not found. Build does not help.

I believe this is a bug.

*The first mistake a made was accepting the upgrade from Visual Studio when prompted. This is what I have done:
1. Opened an existing Script Task on a package that was working and has been built and tested.
2. Click Edit Script.
3. Changed nothing and just clicked save.
4. Get the following error: Scripts contained in the package have compilation errors. Do you want to save changes? (Remember, I changed nothing!)
5. Open the script back up by clicking on Edit Script again
6. Go Build and select Build ST_3d9cab1ad210480b84e9145860270c8b


74910-build-2021-03-05-111513.jpg

  1. The build fails with the following error: Could not find a part of the path 'C:\Users\<User>\AppData\Local\Temp\Vsta\424749ca2d4f4772b6db785f714272fb_out'…


![74933-build-error-2021-03-05-111711.jpg][2]

Other things I have done: I have deleted the script and created a new one. Even if you add no code, and just click save and close it removes the binary code. Clicking build just shows the error that I listed in list item 5 above.

There is nothing that I’ve been able to do to have it recreate or not remove the binary code. I have tried to fix it by uninstalling Visual Studio, uninstalling Microsoft.DataTools.IntegrationServices and every sign of Visual Studio ever existing on my machine through the Control Panel. Reinstalled Visual Studio and the issue is back.

Thanks!

vs-generalsql-server-integration-servicesvs-extensions
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AnthonyGreen avatar image
0 Votes"
AnthonyGreen answered ·

If you have updated to VS 2019 16.9.0 then SSIS is broken for script tasks.

You need to downgrade to 16.8.6 or below.


I am in the same issue but I use community so it's not an easy downgrade unless someone knows how.....

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered ·

Hi @ElaenaBakman-4685 ,

Could you please share the example script in the Script Task?

Hope the following links will be helpful:
1.“The binary code for the script is not found”
This is often caused to to an error or omission in the code in the script task. If you are certain that the code is correct you can go to the script properties and set the PrecompileiIntoBindaryCode to False, the default is set to true. This is under the Properties or in the Script option of the properties window.

2.SSIS Error: The binary code for the script is not found

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 3 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Monalv-msft,

Based on the advice of another user of Visual Studio and SSIS who reached out to me directly and after reviewing the following note that can be located here: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects&fbclid=IwAR1HNsJWyAoG6c1lS1PBmVqLsWNTQEls6mNAFcwU-jYeQRE0kJ8bMzrZ_hM:

There is a regression in VS 2019 16.9 that will cause script task/component not work properly when editing script. Please do NOT upgrade to 16.9 currently. If you have already upgraded to 16.9, please rollback to 16.8 or earlier version if you are using script task/component. VS team is working on the fix. Sorry for any inconvenience.

I followed that advice and uninstalled 16.9 and installed 16.8.6 and the issue was resolved.

Thank you

2 Votes 2 ·
AnthonyGreen avatar image AnthonyGreen ElaenaBakman-4685 ·

Can you advise how to downgrade Community to 16.8.6?

There is no history exe for Community.

0 Votes 0 ·
Monalv-msft avatar image Monalv-msft ElaenaBakman-4685 ·

Hi @ElaenaBakman-4685

I am glad to hear that the issue has been resolved.

If you have a new issue about SSIS, welcome to this forum.

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·
FlorisJanGalesloot-0306 avatar image
0 Votes"
FlorisJanGalesloot-0306 answered ·

I am having the exact same issue after updating VS 2019 last week. After I saw the issue first, I tried to solve it by installing all updates of the installed extensions, to no avail.
The code is correct, it worked before the update.

This also happens in new (empty) projects with a new package by just adding an unmodified script component using the template code.

Regards,
Floris Jan

· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FlorisJanGalesloot-0306

Roll it back to 16.8.6. That one works (see my comment above).

Thanks.

0 Votes 0 ·

Thanks, I ended up restoring my entire dev server as I was running the community edition and could not find a way to rollback the update.

0 Votes 0 ·