Prev: Calling SSIS package from TSQL
Next: DATE - unable to create table using this data type
From: danbridgland on 5 Feb 2009 11:27
Hi,

I'm trying to implement the execution log reports for Reporting
services, I've followed these instructions to the word!, (http://
www.codeplex.com/MSFTRSProdSamples/Wiki/View.aspx?title=SS2008%21Serv...)
However, when I try to execute the SQL agent job, The job fails,
looking at the job history I get the following error message:


"Message
Executed as user: WROPEN\SQLSyncAccount. Microsoft (R) SQL Server
Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright
(C) Microsoft Corp 1984-2005. All rights reserved. Started:
15:23:56 Error: 2009-02-05 15:24:59.17 Code: 0x00000004
Source: Set Time Period 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-02-05 15:24:59.17 Code: 0xC0024107 Source:
Set Time Period Description: There were errors during task
validation. End Error DTExec: The package execution returned
DTSER_FAILURE (1). Started: 15:23:56 Finished: 15:24:59 Elapsed:
62.672 seconds. The package execution failed. The step failed."


Has anyone else come accross this problem or can anyone point me in
the right direction?


Thanks for reading.
Dan
 | 
Pages: 1
Prev: Calling SSIS package from TSQL
Next: DATE - unable to create table using this data type