D
danbridgland
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%21Server%20Management%20Sample%20Reports&referringTitle=Home)
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
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%21Server%20Management%20Sample%20Reports&referringTitle=Home)
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