Schedule Job executes 5 times then fails

[wfairbanks]

I have several jobs schedule and they execute at different times. They execute successfully 5 different nights but then fails on the 6th night.

 

[ecobb]

Is there any indication as to why it fails? Any Errors? Is the server running some other type of process at this time on the 6th night (i.e. shutting everything down to run backups every Saturday at a certain time)?

 

[wfairbanks]

It failed this morning and the error message I am receiving is below:
DTSRun OnError: Copy Data from EmployeeMaster_Checks to [Payroll].[dbo].[EmployeeMaster_Checks] Step, Error = -2147467259 (80004005) Error string: Unspecified error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from... Process Exit Code 1. The step failed.

I hope this helps. I desperately need this to be successful consistently. Also, in the workflow properties, I have checked to close the connection on completion. This does not seem to have any effect one way or the other.

Thanks in advance.
WF