- Open the VSTA IDE
- Add a web reference to the reporting service
- Build the code, and close the IDE
- While she tried to close the script window, an error window "binary code is not found" popped up She went back and checked her code, nothing was added yet except for the web reference
- She set the "delay verification" to true to remove the red cross, but she executed the script task, the task failed with identical error message.
When we do a google search, basically you can find hints like:
- The code is wrong, check your syntax
- Set "delay verification" to true if you are using SSIS2008 and later versions
- Set "PrecompileScriptIntoBinaryCode" to true if you are using SSIS2005
Obviously none of above is applicable in her case. So I grab the package and run on my PC, guess what? Nothing is wrong on my PC. So problem must occurs on her machine.
Now look at MSDN at https://msdn.microsoft.com/en-us/library/ms152787.aspx, it says "to develop Reporting Services applications based on the Web service...using Microsoft Visual Studio and the Microsoft .NET Framework SDK"
Now it looks much clear. I downloaded .Net Framework SDK and installed on here machine. Now she can build the script task with web service.
So considering the case I posted before DBCC Error, searching online is good, but you still need to do your own task. :D
Hi Chi,
ReplyDeleteThanks for your post, this simple solution solved a few hours problem.
Visual Studio 2017
SSIS 2016