Sql server 2008 SSIS Package

• Zahid Hasan

  SSC Veteran

  Points: 278

  More actions

  December 30, 2009 at 3:36 pm

  #215008

  Hi There, i have an ssis package that was created using sql 2008 business intelligence dev studio. Its run fine when i run it manuall on my machine. But when i imported it on our test server and schedule job i get this error.

  Message

  Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2009-12-30 16:05:39.62 Code: 0xC0024107 Source: Script Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 4:05:39 PM Finished: 4:05:39 PM Elapsed: 0.313 seconds. The package executed successfully. The step succeeded.

  Does anyone seen this before and any idea how to go about to fix this?

  Thanks

• mmurudker

  SSC Enthusiast

  Points: 156

  More actions

  March 20, 2012 at 6:37 am

  #1461572

  hi, did u ever get a response to this question? I'm having pretty much the same issue and cannot find a solution