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