Acquired Connection method failed error code 0xC0014009
-
Hi,
We have a set of around 24 packages running on daily basis.
Source - ODBC (hadoop db)
destination - SQL server
From past few days, we are getting following error on Source to Stage dataflow:
We have scheduled 5 runs for the package before termination, so sometimes it fails to establish connection in first run but succeeds in next attempts.
I tried running the package after setting 32 bit true and delay validation false as well.
Any other pointers where we can check this?
-
Are you saying that the package fails on its first run, but you don't want that to happen?
Or are you asking for help diagnosing the connection issue?
Please clarify.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Yes, the package fails on the first run, but gets executed in second or third turn. We have both 64 bit and 32 bit ODBC drivers installed and all 24 packages were absolutely fine till last week.
-
See if there is any patch or latest security updates happened, it may break ODBC connectivity using SSIS.
You case may be odbc connection for mysql connector 8.0 (source) and sql server 2017 destination.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply