Deploying Data Factory through ARM - Data Factory not recognizing Stored Procedure

0
votes

On deploying my ARM for my Data Factory, it is not recognizing my stored procedure and giving this value as my 'Stored procedure name': [object Object]

enter image description here

Here is how my stored procedure is declared in ARM Template:

{
        "name": "execute_teststoredproc",
        "type": "SqlServerStoredProcedure",
        "dependsOn": [],
        "policy": {
            "timeout": "7.00:00:00",
            "retry": 0,
            "retryIntervalInSeconds": 30,
            "secureOutput": false,
            "secureInput": false
        },
        "userProperties": [],
        "typeProperties": {
            "storedProcedureName": {
                "value": "[[dbo].[teststoredproc]"
            }
        },
        "linkedServiceName": {
            "referenceName": "TargetSQLDB",
            "type": "LinkedServiceReference"
        }
    }

Anyone knows why this is happening? Thanks.

1
azureazure-data-factoryazure-resource-managerazure-data-factory-2

1 Answers

0
votes

Apparently you cannot use the value field for storedProcedureName. Simple yet subtle difference that can make you waste unnecessary time.

Correct code:

    "typeProperties": {
        "storedProcedureName": "[[dbo].[teststoredproc]"
    }

instead of 

    "typeProperties": {
        "storedProcedureName": {
            "value": "[[dbo].[teststoredproc]"
        }
    }