December 16, 2013 at 5:14 am
Hi,
I have a package that extract data from MySQL source. I am using ADO NET source to get the data. The target tables is SQL SERVER 2012. The package is running OK each hour with sql server agent. The package fails randomly (every few days).
this is the error:
Error: 2013-12-15 20:11:24.90 Code: 0xC0208449 Source: source1 ADO NET source1 [71] Description: ADO NET Source has failed to acquire the connection {C2F3842B-D6F2-4D88-841E-3D19356730DE} with the following error message: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.". End Error Error: 2013-12-15 20:11:24.90 Code: 0xC0047017 Source: source1 SSIS.Pipeline Description: ADO NET source1 failed validation and returned error code 0xC0208449.
all the sources and targets at the package has unlimited timeout (commandSQL set to 0). so it's weird that the package failed on timeout. I'm not sure about the part of the validation. Do you have any idea what to do? or why it's happening?
Thanks
December 16, 2013 at 5:19 am
I think the timeout is in trying to connect, not in running any command. Maybe the MySQL server is down, or there's a problem on the network?
John
December 16, 2013 at 5:23 am
Hi,
Thanks for the quick response.
The server is not down, and as I said - it's happening randomly. If I run the package again after it failed - It will work fine.
December 16, 2013 at 5:36 am
The error message indicates problems connecting to the source. Do you see any errormessages in MySQL? Can you setup a monitoring in MySQL to record connections, connection-endings and connection-attemps?
You could also temporaraly run a continuous PING command (storing results into a txt-file) from the server running the SSIS package to the MySQL server. This will give you insight about the connection between the servers.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply