DTS Package Timeoutgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have a DTS Package that runs a stored procedure. The stored procedure has the following tasks: 1. pulls data from a large table into a very small one 2. sends an email with the results of a query on the small table. It has run successfully every morning. This morning I received a timeout error and the following error in the history details of the DTS package. Since I am new at this I am trying to figure out what the error message means and am having a hard time tring to locate any information. Any suggestions for how to interpret error or any advice would be appreciated. I have looked at Books on Line and the MS newsgroups and the MS knowledge and am just not looking in the correct places.
...un: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft OLE DB Provider for ODBC Drivers Error Description: [Microsoft][ODBC SQL Server Driver]Timeout expired Error on Line 13 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE DB Provider for ODBC Drivers Error Description: [Microsoft][ODBC SQL Server Driver]Timeout expired Error on Line 13 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
-- Anonymous, June 29, 2001
It looks to me like a job step failed or timed out. You should be able to determine the exact step that failed by looking at the history of the DTS job. Double check you timeout value, and check it against how long things ran before it failed and consider increasing the timeout.
This doesn't sound like it changes data, so it should not be a major disruption to users to run it or run parts of it in order to determine the cause of failure.
-- Anonymous, July 01, 2001
Eric, Thanks for your answer. I have checked the items you specified.
The job only has one step and step 1 is the item that failed. Step 1 only runs a stored procedure. The above message was from the history of the DTS job.
The only reference to timeout time I could find was to change was the query timeout value in Tools-Option-Connections. My query timeout value is 0 which should be "Wait Indefinitely". Is there any other location where I can change a timeout value?
-- Anonymous, July 02, 2001