Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package timeout and validation failure Expand / Collapse
Author
Message
Posted Monday, December 16, 2013 5:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 21, 2013 11:56 PM
Points: 3, Visits: 14
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
Post #1523166
Posted Monday, December 16, 2013 5:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 5,306, Visits: 9,686
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
Post #1523168
Posted Monday, December 16, 2013 5:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 21, 2013 11:56 PM
Points: 3, Visits: 14
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.
Post #1523169
Posted Monday, December 16, 2013 5:36 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 7:12 AM
Points: 2,255, Visits: 2,717
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.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1523173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse