ADF 2011 Pipeline Error

Question

I'm trying to run an SSIS package in ADF via the Execute SSIS Package activity. We are using the SSIS-IR setup with a self-hosted proxy using a self hosted IR and Azure Files. The self hosted IR is able to run normal ADF pipelines.

Whenever I try to run the package I get the following error:

Error details
Error code
2011
Troubleshooting guide
Failure type
User configuration issue
Details
The given key was not present in the dictionary.
Source
Pipeline

Sample pipeline json:

{
    "name": "Pipeline Central Cube - Data",
    "properties": {
        "activities": [
            {
                "name": "Activity Central Cube - Data",
                "description": null,
                "type": "ExecuteSSISPackage",
                "dependsOn": [],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [],
                "typeProperties": {
                    "packageLocation": {
                        "packagePath": "\\mystoragedev.file.core.windows.net\ssis\packages\Central Cube - Data.dtsx",
                        "type": "File",
                        "typeProperties": {
                            "accessCredential": {
                                "domain": "Azure",
                                "userName": "mystoragedev",
                                "password": {
                                    "type": "SecureString",
                                    "value": "**********"
                                }
                            }
                        }
                    },
                    "runtime": "x64",
                    "connectVia": {
                        "referenceName": "DARTT-SSIS-IR",
                        "type": "IntegrationRuntimeReference"
                    },
                    "loggingLevel": "Verbose",
                    "logLocation": {
                        "logPath": "\\mystoragedev.file.core.windows.net\ssis\logs",
                        "type": "File",
                        "typeProperties": {
                            "accessCredential": {
                                "domain": "Azure",
                                "userName": "mystoragedev",
                                "password": {
                                    "type": "SecureString",
                                    "value": "**********"
                                }
                            }
                        }
                    }
                }
            }
        ],
        "annotations": [],
        "lastPublishTime": "2020-10-23T10:00:33Z"
    },
    "type": "Microsoft.DataFactory/factories/pipelines"
}

The thing is, I've checked the storage account ssis\logs directory and nothing gets put in there, and there is nothing in the self hosted IR logs on the VM. So I'm not sure how to go about debugging this

p.s. Another strange issue is whenever I queue up a debug run, the activity gets permastuck in the 'queued' status, but I can do Add Trigger -> Trigger Now

Answer 1

I believe the issue ended up being a missing project parameter using for the connection manager. Now I am facing a different error.

Answer 2

Hi @Dave8200 ,

Hope the following links will be helpful:

1. Azure Data Factory Execute SSIS Package Activity
2. Run an SSIS package with the Execute SSIS Package activity in Azure Data Factory

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet.