Upgrade to SQL2005 SP2, you fools!

Posted by BI Monkey on Tuesday, December 2, 2008 · Leave a Comment  Subscribe via RSS

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 , , ,

Subscribe via RSS

Comments

Please leave a comment or ask the BI Monkey for more info.
To prevent spamming, comments have to be approved so they will not appear instantly.
If you want a pic to show with your comment, go get a gravatar