{
    "name": "pipeline2",
    "properties": {
        "activities": [
            {
                "name": "CopyData_REF",
                "description": "File to PDS",
                "type": "Copy",
                "dependsOn": [],
                "policy": {
                    "timeout": "7.00:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [
                    {
                        "name": "Source",
                        "value": "dev/Download/AA_person.txt"
                    },
                    {
                        "name": "Destination",
                        "value": "dbo.AA_preson"
                    }
                ],
                "typeProperties": {
                    "source": {
                        "type": "DelimitedTextSource",
                        "storeSettings": {
                            "type": "AzureBlobStorageReadSettings",
                            "recursive": true,
                            "enablePartitionDiscovery": false
                        },
                        "formatSettings": {
                            "type": "DelimitedTextReadSettings"
                        }
                    },
                    "sink": {
                        "type": "SqlMISink",
                        "preCopyScript": "truncate table [dbo].[AA_person]",
                        "writeBehavior": "insert"
                    },
                    "enableStaging": false,
                    "enableSkipIncompatibleRow": true,
                    "validateDataConsistency": true,
                    "logSettings": {
                        "enableCopyActivityLog": true,
                        "copyActivityLogSettings": {
                            "logLevel": "Warning",
                            "enableReliableLogging": false
                        },
                        "logLocationSettings": {
                            "linkedServiceName": {
                                "referenceName": "devdatalake1",
                                "type": "LinkedServiceReference"
                            },
                            "path": "dev/Log"
                        }
                    },
                    "translator": {
                        "type": "TabularTranslator",
                        "mappings": [
                            {
                                "source": {
                                    "name": "ID",
                                    "type": "String",
                                    "physicalType": "String"
                                },
                                "sink": {
                                    "name": "id",
                                    "type": "Int32",
                                    "physicalType": "int"
                                }
                            },
                            {
                                "source": {
                                    "name": "NAME",
                                    "type": "String",
                                    "physicalType": "String"
                                },
                                "sink": {
                                    "name": "name",
                                    "type": "String",
                                    "physicalType": "varchar"
                                }
                            }
                        ],
                        "typeConversion": true,
                        "typeConversionSettings": {
                            "allowDataTruncation": true,
                            "treatBooleanAsNumber": false
                        }
                    }
                },
                "inputs": [
                    {
                        "referenceName": "File_AA_person",
                        "type": "DatasetReference"
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "JW_TEst",
                        "type": "DatasetReference"
                    }
                ]
            }
        ],
        "folder": {
            "name": "SBX"
        },
        "annotations": []
    }
}