I have to edit a SSIS package written by somebody else. On loading the package in Visual Studio I was getting error "Failed to decrypt protected XML node". I resolved this error by setting property Protection Level to "Do not Save Sensitive Data" at project and individual package(dtsx) level. I was able to build solution successfully after that without any errors and was able to execute the package as well successfully. Now upon deployment of this package to Server, when I try to run it form SQL Server Agent Job, I get below errors: 1) “The binary code for the script is not found” 2) The type or namespace is missing..., could not be found in ScriptMain.cs
Any idea on how it can be resolved will be helpful.