December 16, 2013 at 10:56 am
We have a vendor product that is doing nightly update to process something in a table.
And we also have a SSIS package that runs import from that table to another db on another server.
But the SSIS job failed,
Code: 0xC0047062 Source: Import ADO NET Source [1] Description: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: component "ADO NET Source" (1) failed the pre-execute phase and returned error code 0x80131904. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:00:01 AM Finished: 5:00:35 AM Elapsed: 34.328 seconds. The package execution failed. The step failed.
Could it be the reason that update process on the server locked the table, and the SSIS packege could not do select?
Thanks,
December 16, 2013 at 12:39 pm
It's possible. The source component got a timeout, which can be caused by locking.
Can you force SSIS to run after the update? If not, you can maybe try another isolation level.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply