Validation error. Script Task : The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.
错误已修复(只需要成功构建脚本)并且与问题无关.
在我在StackOverflow上搜索答案的过程中,我发现了很多关于这种“预编译”设置的讨论,但是在点击SSIS中的几乎所有内容之后,我找不到它,因此问题就出现了.
我怀疑它是在以后的版本中删除但是无法证明它.如果您碰巧知道答案,请告诉我.
解决方法
Configuring the Script Component in the Script Component Editor
In sql Server 2008 Integration Services (SSIS) and later versions,all
scripts are precompiled. In prevIoUs versions,you specified whether
scripts were precompiled by setting a Precompile property for the
task.
更新 – 感谢@billinkc,我已经确定了记录变更的部分：
Unlike earlier versions where you could indicate whether the scripts were precompiled,all scripts are precompiled in sql Server 2008 Integration Services (SSIS). When a script is precompiled,the language engine is not loaded at run time and the package runs more quickly. However,precompiled binary files consume significant disk space.
