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.
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?