July 23, 2015 at 6:57 am
How would I find out what happened to create the error below... It is hard to believe it was a time-out issue since the elapsed time is only about 30 seconds. I re-ran the job and it completed the second time, so it is also hard to believe the remote server was not answering.
Started: 5:06:55 AM Error: 2015-07-23 05:07:37.40 Code: 0xC02090F5 Source: Data Flow Task ADO NET Source [1] Description: The component "ADO NET Source" (1) was unable to process the data. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. End
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ADO NET Source" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:06:55 AM Finished: 5:07:37 AM Elapsed: 42.182 seconds. The package execution failed. The step failed.
July 23, 2015 at 8:57 am
dwilliscp (7/23/2015)
How would I find out what happened to create the error below... It is hard to believe it was a time-out issue since the elapsed time is only about 30 seconds. I re-ran the job and it completed the second time, so it is also hard to believe the remote server was not answering.Started: 5:06:55 AM Error: 2015-07-23 05:07:37.40 Code: 0xC02090F5 Source: Data Flow Task ADO NET Source [1] Description: The component "ADO NET Source" (1) was unable to process the data. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. End
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ADO NET Source" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:06:55 AM Finished: 5:07:37 AM Elapsed: 42.182 seconds. The package execution failed. The step failed.
Perhaps you should check what the timeout period is actually set to.
July 24, 2015 at 12:52 am
Ditto, you should check what the timeout period is actually set to.
Also, try connecting your source server and see if it is getting connected. Also, try executing your source query/table on your source table and check how much time it is taking.
You can then compare it with the timeout period.
Cheers!.
____________________________________________________________
APJuly 24, 2015 at 7:05 am
How do you find the timeout.. in SSIS? I looked around but could not locate.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply