CODEWITHSUNDEEP
visual-studioazuressisodataetl
Pau Balaguer
Pau Balaguer

Reputation: 63

SSIS OData source works in Visual Studio 2017 but fails when run in Azure Data Factory

When I test the OData source connection in my host with Visual Studio 2017, the connection is ok. However, when I push the SSIS package into the Azure Data Factory and I run it, it fails. The only error message that I receive is:

{
    "SsisDBOperationGuid": "XXXXXXXXXXXXXXXXXX",
    "SsisDBOperationId": YYYYYY,
    "OperationErrorMessages": "4/11/2019 9:54:21 AM +00:00 : Tarea Flujo de datos:Error: The connection \"Connection\" cannot be found. Verify that the connection manager has a connection with that name.\r\n\n4/11/2019 9:54:21 AM +00:00 : Tarea Flujo de datos:Error: Origen OData failed validation and returned error code 0xC020801A.\r\n\n4/11/2019 9:54:21 AM +00:00 : Tarea Flujo de datos:Error: One or more component failed validation.\r\n\n",
    "effectiveIntegrationRuntime": "integrationRuntime1 (West Europe)",
    "executionDuration": 10197
}

The main error message is:

Error: The connection \"Connection\" cannot be found. Verify that the connection manager has a connection with that name.

Upvotes: 2

Views: 666

Answers (1)

Hadi
Hadi

Reputation: 37348

I think the error cause is the difference between the Visual studio default language and the azure language. Try changing the connection name from the package XML (just open the .dtsx file with a text editor). You can refer to the following post for more details:

Upvotes: 1

Related Questions