Upgrade to SQL2005 SP2, you fools!

Posted by on Tuesday, December 2, 2008 · Leave a Comment 

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.

Filed under Integration Services, SQL Server · Tagged with , , ,

About BI Monkey

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!