我在执行SSIS脚本组件时遇到问题。老实说,我正在学习SSIS,对于脚本组件,我正在通过The Script Component as a Transformation文章。到目前为止,我已经做了那里所说的一切。但是当我尝试执行这个包时,我遇到了下面的错误
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [Script Component [16]]: The script component is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Component Editor by clicking Design Script button to cause binary code to be generated.
Error at Data Flow Task [DTS.Pipeline]: "component "Script Component" (16)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
稍微搜索一下,就会发现下面的Package Validation Error 。因此,在经历了这些之后,我明白了问题的原因,但我不知道如何纠正它。此外,调试是不可能的。
请帮帮我。
编辑
最后,我发现预编译选项应该设置为FALSE。默认值为TRUE。它解决了问题。
谢谢
https://stackoverflow.com/questions/2333371
复制相似问题