Application team reported me that one of the SSIS package is failing after recent changes. It was failing with message “Binary Code for the script is not found”
I have been asked to troubleshoot the issue. I have opened the SSIS package in SQL Server Data tools and try to run the package from SSDT. Here is the error i have received
The package was using Script Task and i have opened the script tasks to see any coding/syntax errors. I found there was missing semicolon and un compiled code. I have modified the logic in Script task and save the package.
After that i have ran the package and it is successful.
Error “The Binary code for the script is not found” usually occurs when you use Script task in SSIS and save the task with errors. Edit the script task, correct the issues and then execute the package.
Hope you enjoyed the post!
LinkedIn: LinkedIn Profile