Error at oled destination

Question

TITLE: Package Validation Error

---

Package Validation Error

---

ADDITIONAL INFORMATION:

Error at Package: The connection "{ED0A6B78-CF34-429E-86CF-4E157EE8CD5E}" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Error at Data Flow Task 1 [SSIS.Pipeline]: Cannot find the connection manager with ID "{ED0A6B78-CF34-429E-86CF-4E157EE8CD5E}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "OLE DB Source.Connections[OleDbConnection]" in the connection manager collection of "OLE DB Source". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.

Error at Data Flow Task 1 [SSIS.Pipeline]: OLE DB Source failed validation and returned error code 0xC004800B.

Error at Data Flow Task 1 [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task 1: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

---

BUTTONS:

OK

---

Answer 1

Hi @Siqi Zhao ,

Every SSIS package has multiple Adapters, Tasks, Connections, etc. Internally they have a unique identifier as a GUID. It seems that GUIDs in your package are out of sync.

Please try to follow the following steps:

1. Edit you connection, and test it by clicking "Test Connection". And make sure it is connecting successfully.
2. Go to the Data Flow Task (DFT), edit Source and/or Destination Adapters. and refresh connections in them.

That should resolve the issue.

Answer 2

Hi @Siqi Zhao,

Cannot find the connection manager with ID "{ED0A6B78-CF34-429E-86CF-4E157EE8CD5E}" in the connection manager collection due to error code 0xC0010009

Please check your source connection manager and make sure you could connect to it successfully.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.