Upgrade to SQL2005 SP2, you fools!

Hitting one of these 3 messages in SSIS on SQL2005?

  • The task is configured to pre-compile the script, but binary code is not found
  • The script component is configured to pre-compile the script, but binary code is not found
  • The task cannot execute in 64-bit environment because the script is not pre-compiled

Hotfixes are available here for Build 1399 and here for Build 1500

All the above can be fixed by applying SP2. And really, if you haven’t put SP2 on your SQL2005 you had better have a good reason for it, as there’s lots of other little things which will catch you out on your BI projects if you don’t. It was released in March 2007 so it’s not exactly a new patch either.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>