Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
Are you on SQL Server 2005 RTM? –  billinkc Sep 30 '13 at 15:08
    
afaik no, it is SQL Server 9.0.5057 –  mnemonic Sep 30 '13 at 15:10
    
Does this article cover your issue? KB932556 –  billinkc Sep 30 '13 at 15:12
    
huh ... currently, downloading the server update ..... –  mnemonic Sep 30 '13 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 '13 at 15:53
add comment

1 Answer 1

up vote 2 down vote accepted

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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