January 22, 2009 at 6:16 am
Hi,
we are testing our packages on a new Server, 64bit, SQL Server 2005, SP2, and have problems with ScriptTasks:
Precompiled script failed to load. The computer that is running the Script Task does not have a compiler capable of recompiling the script. To recompile the script, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885).
The mentioned Knowledge Base article did not solve the problem as we already have installed SP2.
Did anyone experience the problem?
Tobias
January 22, 2009 at 6:40 am
Make sure the workstation you are building the packages on has the same version and service pack (and patch) of SSIS.
Make sure the precompile property on the script component is set to true.
Even with that all correct, I get that error from time-to-time after I deploy a package. I usually just have to open the package on my workstation, open the script task and open the script, save the script, save the changes to the task, and save the package - then re-deploy. Once it works, it seems to continue to work fine on the server.
It seems that if I get the latest version from source control (we use Team) that I have to open at least one of the script components and re-save it before I deploy. I have gotten into the habit of always re-saving a script task as the very last step before re-deploying and changes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply