{
    "name": "pipelineCopy",
    "properties": {
        "activities": [
            {
                "name": "Copy_file",
                "type": "Copy",
                "dependsOn": [],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [],
                "typeProperties": {
                    "source": {
                        "type": "ExcelSource",
                        "additionalColumns": [
                            {
                                "name": "test",
                                "value": {
                                    "value": "@bool(0)",
                                    "type": "Expression"
                                }
                            },
                            {
                                "name": "INSERT_TIMESTAMP",
                                "value": {
                                    "value": "@utcnow()",
                                    "type": "Expression"
                                }
                            },
                            {
                                "name": "UPDATE_TIMESTAMP",
                                "value": {
                                    "value": "@utcnow()",
                                    "type": "Expression"
                                }
                            }
                        ],
                        "storeSettings": {
                            "type": "AzureBlobFSReadSettings",
                            "recursive": true,
                            "enablePartitionDiscovery": false
                        }
                    },
                    "sink": {
                        "type": "SqlDWSink"
                    },
                    "enableStaging": true,
                    "stagingSettings": {
                        "linkedServiceName": {
                            "referenceName": "LS_ADLS2",
                            "type": "LinkedServiceReference"
                        },
                        "path": "container1/stagingfolder"
                    },
                    "translator": {
                        "type": "TabularTranslator",
                        "mappings": [
                            {
                                "source": {
                                    "name": "SupplierNumber",
                                    "type": "String",
                                    "physicalType": "String"
                                },
                                "sink": {
                                    "name": "VENDOR_ID",
                                    "type": "String",
                                    "physicalType": "char"
                                }
                            },
                            {
                                "source": {
                                    "name": "DocumentNumber",
                                    "type": "String",
                                    "physicalType": "String"
                                },
                                "sink": {
                                    "name": "DOCUMENT_REF",
                                    "type": "String",
                                    "physicalType": "char"
                                }
                            },
                            {
                                "source": {
                                    "name": "DocumentDate",
                                    "type": "String",
                                    "physicalType": "String"
                                },
                                "sink": {
                                    "name": "DOCUMENT_DATE",
                                    "type": "DateTime",
                                    "physicalType": "datetime2"
                                }
                            },
                            {
                                "source": {
                                    "name": "DocumentAmount",
                                    "type": "String",
                                    "physicalType": "String"
                                },
                                "sink": {
                                    "name": "DOCUMENT_AMOUNT",
                                    "type": "Decimal",
                                    "physicalType": "decimal",
                                    "scale": 6,
                                    "precision": 16
                                }
                            },
                            {
                                "source": {
                                    "name": "INSERT_TIMESTAMP"
                                },
                                "sink": {
                                    "name": "INSERT_TIMESTAMP",
                                    "physicalType": "datetime2"
                                }
                            },
                            {
                                "source": {
                                    "name": "UPDATE_TIMESTAMP"
                                },
                                "sink": {
                                    "name": "UPDATE_TIMESTAMP",
                                    "physicalType": "datetime2"
                                }
                            },
                            {
                                "source": {
                                    "name": "TEST_RECORD"
                                },
                                "sink": {
                                    "name": "TEST_RECORD",
                                    "physicalType": "bit"
                                }
                            }
                        ],
                        "typeConversion": true,
                        "typeConversionSettings": {
                            "allowDataTruncation": true,
                            "treatBooleanAsNumber": true
                        }
                    }
                },
                "inputs": [
                    {
                        "referenceName": "DS_ADLS2_EXCEL_SIMPLE_COPY",
                        "type": "DatasetReference",
                        "parameters": {
                            "FileName": "VENDOR_INFO.xlsx",
                            "SheetName": "Sheet1",
                            "root": "container1",
                            "folderLocation": "stagingfolder"
                        }
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "DS_SYNAPSE_DWH_DEV",
                        "type": "DatasetReference",
                        "parameters": {
                            "schema": "INGESTION",
                            "table": "VENDOR_DETAILS"
                        }
                    }
                ]
            }
        ],
        "folder": {
            "name": "PL_VENDOR_DETAILS"
        },
        "annotations": []
    }
}