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

2
votes

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.

1
visual-studioazuressisodataetl
You probably need to install it into the Azure SSIS runtime. Is this a MS component or a third party component? docs.microsoft.com/en-us/azure/data-factory/… – Nick.McDermaid
I am using a normal OData component. – Pau Balaguer
Did you download and install it as this link says mssqltips.com/sqlservertip/3220/… ? If so you need to do the same on the Azure SSIS runtime. – Nick.McDermaid
I have downloaded and installed this component and it works fine in my computer. Do you know where is the problem? – Pau Balaguer
@Nick.McDermaid i think the cause is the language difference between local machine and azure data factory. – Hadi

1 Answers

1
votes

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: