SSIS Script Task not compiling binary code

Posted on 2007-08-10
Last Modified: 2013-11-30
I did design some SSIS packages that contain Script Tasks. Originally, option PrecompileScriptIntoBinaryCode was set to true and everything was working fine. All the sudden, all my packages with Script Tasks are giving me this error "The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated".
If I change the option to False everything seems to work but I am not sure my script is being compiled if I make a change to it.

Does anyone know why all the sudden I am getting this error message when it was working fine before?
Thanks for your help,
Question by:norgrenit
    LVL 11

    Accepted Solution

    I could actually be a problem on the client end if you are using Vista or certain hotfixes of .NET Framework 2.0. -

    Author Comment

    I haven't had a chance to implement SP2 yet but I'll try to get it done today.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now