1

Within a script component, a strange error occurs.

  • the (vb.net) code leads to build succeeded
  • as mentioned, build done

BUT and that's not really awesome (and, yes, design script was clicked):

Error 1 Validation error. Load Observations: Script Load into MeasuringParameters & Observations [194]: 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. LoadTransMeas.dtsx 0 0

any hints how to resolve this issue?

5
  • Are you on SQL Server 2005 RTM?
    – billinkc
    Sep 30, 2013 at 15:08
  • afaik no, it is SQL Server 9.0.5057
    – mnemonic
    Sep 30, 2013 at 15:10
  • Does this article cover your issue? KB932556
    – billinkc
    Sep 30, 2013 at 15:12
  • huh ... currently, downloading the server update .....
    – mnemonic
    Sep 30, 2013 at 15:23
  • the server number above was wrong cause it was my local server and the sql server within a vm is used (build nr<1500). hence, the wrong hotfix was installed & the correct hotfix was not able to install due to my fault. however, now it works. (and the sql server in the vm will be reinstalled anyway which has no relation with the wrong hotfix). thanks a lot. you could post your comment as an answer.
    – mnemonic
    Sep 30, 2013 at 15:53

1 Answer 1

2

Since you're dealing with 2005, there were some known issues with scripts.

For the reported version of 9.0.5057, you'd want to look at KB932556

Earlier version (RTM) of SQL Server would have KB932557 applied

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.