Post reply

pre-compile script error in SSIS

  • July 3, 2012 at 12:19 am

    #263252

    Hi, I have a simple script task(with msgbox alone) in SSIS package. When I execute the task I got this error:

    Error at Script Task: 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.

    Please help me in resolving the issue.

    other info:

    SQL server 2005

    Visual studio: 2005

    Thanks in Advance

  • July 3, 2012 at 1:41 am

    #1508040

    Did you open the script and save it?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 3, 2012 at 1:58 am

    #1508048

    Do you get any build errors?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 3, 2012 at 3:38 am

    #1508100

    Yes , am able to open and save the script .

    But not able to build the SSIS package because the below script validation failure.

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

    Please advise.

    Thanks in Advance

  • July 3, 2012 at 4:18 am

    #1508127

    Please see the Overview section here. Could it be this?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply