pre-compile script error in SSIS

• hamsa_apj

  SSC Eights!

  Points: 825

  More actions

  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

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  July 3, 2012 at 1:58 am

  #1508048

  Do you get any build errors?

  ---

• hamsa_apj

  SSC Eights!

  Points: 825

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  July 3, 2012 at 4:18 am

  #1508127

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

  ---