Pre-Compiled Script Task Error in SSIS 2005

There is an issue with script tasks in SSIS 2005 that could come up occasionally.  It is generally an issue that shows up in a 64-bit environment where the script can’t be pre-compiled.  The error that will show up states that “The task is configured to pre-compile the script, but binary code is not found.”  There is not a fix for this inside SSIS as you can’t set the script to Pre-compile false as the error will just change to the script can’t be compiled, please switch the mode to pre-compile true.  Fortunately there are a couple of fixes.  The first of which is to open the script task and click on edit script.  Allow the code editor to open and simply close the editor.  When you close the script task configuration the red x should go away.  This does not always work though.  If there is a deeper issue that prohibits this form fixing the issue then there is a hot fix that can be applied to remedy the situation.
From looking at what all is in the latest service pack I don’t see that this hotfix is there.  On a recent troubleshooting session with a client they had the latest service pack and still had this issue which was then fixed by applying this hotfix.  You will need to restart the server or machine that this is applied to so be aware of that before applying this to a server that is critical in the middle of the day.
For information on the hotfix visit the knowledge base page at http://support.microsoft.com/kb/932556/[EN]/
To download the hotfix visit the download center at http://www.microsoft.com/downloads/en/details.aspx?familyid=8AF6C597-0F18-4E61-B3D2-AAD66CDCACF5&displaylang=en

About the author

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Add comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Bradley Schacht

Bradley Schacht is a Senior Program Manager on the Microsoft Azure Synapse Analytics team based in Jacksonville, FL. He has worked with Microsoft SQL Server and Azure data services since 2009 as a consultant, trainer, and architect. He has co-authored 4 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. Bradley enjoys solving interesting problems and teaching others to use new technology. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).

Follow Me