{
    "name": "ExploreDependencies",
    "properties": {
        "activities": [
            {
                "name": "Copy_DimCustomer_AC",
                "type": "Copy",
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "typeProperties": {
                    "source": {
                        "type": "SqlSource"
                    },
                    "sink": {
                        "type": "SqlSink",
                        "writeBatchSize": 10000
                    },
                    "enableStaging": false
                },
                "inputs": [
                    {
                        "referenceName": "DimCustomer_SRC_DS",
                        "type": "DatasetReference"
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "DimCustomer_DST_DS",
                        "type": "DatasetReference"
                    }
                ]
            },
            {
                "name": "Log_success_status_AC",
                "type": "SqlServerStoredProcedure",
                "dependsOn": [
                    {
                        "activity": "Copy_DimCustomer_AC",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "typeProperties": {
                    "storedProcedureName": "[dbo].[Usp_LogActivityStatus]",
                    "storedProcedureParameters": {
                        "ACName": {
                            "value": "Log_success_status_AC",
                            "type": "String"
                        },
                        "ExecStatus": {
                            "value": "Success",
                            "type": "String"
                        },
                        "PipelineName": {
                            "value": {
                                "value": "@pipeline().Pipeline",
                                "type": "Expression"
                            },
                            "type": "String"
                        }
                    }
                },
                "linkedServiceName": {
                    "referenceName": "SqlServerLS_Dst",
                    "type": "LinkedServiceReference"
                }
            },
            {
                "name": "Log_failure_status_AC",
                "type": "SqlServerStoredProcedure",
                "dependsOn": [
                    {
                        "activity": "Copy_DimCustomer_AC",
                        "dependencyConditions": [
                            "Failed"
                        ]
                    }
                ],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "typeProperties": {
                    "storedProcedureName": "[dbo].[Usp_LogActivityStatus]",
                    "storedProcedureParameters": {
                        "ACName": {
                            "value": "Log_failure_status_AC",
                            "type": "String"
                        },
                        "ExecStatus": {
                            "value": "Failure",
                            "type": "String"
                        },
                        "PipelineName": {
                            "value": {
                                "value": "@pipeline().Pipeline",
                                "type": "Expression"
                            },
                            "type": "String"
                        }
                    }
                },
                "linkedServiceName": {
                    "referenceName": "SqlServerLS_Dst",
                    "type": "LinkedServiceReference"
                }
            },
            {
                "name": "Log_skipped_status_AC",
                "type": "SqlServerStoredProcedure",
                "dependsOn": [
                    {
                        "activity": "Log_success_status_AC",
                        "dependencyConditions": [
                            "Skipped"
                        ]
                    }
                ],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "typeProperties": {
                    "storedProcedureName": "[dbo].[Usp_LogActivityStatus]",
                    "storedProcedureParameters": {
                        "ACName": {
                            "value": "Log_skipped_status_AC",
                            "type": "String"
                        },
                        "ExecStatus": {
                            "value": "Skipped",
                            "type": "String"
                        },
                        "PipelineName": {
                            "value": {
                                "value": "@pipeline().Pipeline",
                                "type": "Expression"
                            },
                            "type": "String"
                        }
                    }
                },
                "linkedServiceName": {
                    "referenceName": "SqlServerLS_Dst",
                    "type": "LinkedServiceReference"
                }
            },
            {
                "name": "Log_completed_status_AC",
                "type": "SqlServerStoredProcedure",
                "dependsOn": [
                    {
                        "activity": "Copy_DimCustomer_AC",
                        "dependencyConditions": [
                            "Completed"
                        ]
                    }
                ],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "typeProperties": {
                    "storedProcedureName": "[dbo].[Usp_LogActivityStatus]",
                    "storedProcedureParameters": {
                        "ACName": {
                            "value": "Log_completed_status_AC  ",
                            "type": "String"
                        },
                        "ExecStatus": {
                            "value": "Completion",
                            "type": "String"
                        },
                        "PipelineName": {
                            "value": {
                                "value": "@pipeline().Pipeline",
                                "type": "Expression"
                            },
                            "type": "String"
                        }
                    }
                },
                "linkedServiceName": {
                    "referenceName": "SqlServerLS_Dst",
                    "type": "LinkedServiceReference"
                }
            },
            {
                "name": "Log_Completed_Success_AC",
                "type": "SqlServerStoredProcedure",
                "dependsOn": [
                    {
                        "activity": "Log_completed_status_AC",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    },
                    {
                        "activity": "Log_success_status_AC",
                        "dependencyConditions": [
                            "Succeeded"
                        ]
                    }
                ],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "typeProperties": {
                    "storedProcedureName": "[dbo].[Usp_LogActivityStatus]",
                    "storedProcedureParameters": {
                        "ACName": {
                            "value": "Log_Completed_Success_AC",
                            "type": "String"
                        },
                        "ExecStatus": {
                            "value": "Completion and success",
                            "type": "String"
                        },
                        "PipelineName": {
                            "value": {
                                "value": "@pipeline().Pipeline",
                                "type": "Expression"
                            },
                            "type": "String"
                        }
                    }
                },
                "linkedServiceName": {
                    "referenceName": "SqlServerLS_Dst",
                    "type": "LinkedServiceReference"
                }
            }
        ]
    }
}