要将.zip文件从本地复制到Blob存储，您应该在ADF中使用二进制数据集。使用ZipDeflate (.zip)压缩类型的文件系统链接服务创建二进制数据集。

的数据
然后，您应该能够将解压缩的文件复制到blob存储中，如下所述：

的
这里是将Zip文件从本地复制到blob存储的管道Json，供您参考：

{
    "name": "Pipeline 2",
    "properties": {
        "activities": [
            {
                "name": "Copy data1",
                "type": "Copy",
                "dependsOn": [],
                "policy": {
                    "timeout": "0.12:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [],
                "typeProperties": {
                    "source": {
                        "type": "BinarySource",
                        "storeSettings": {
                            "type": "FileServerReadSettings",
                            "recursive": true
                        },
                        "formatSettings": {
                            "type": "BinaryReadSettings",
                            "compressionProperties": {
                                "type": "ZipDeflateReadSettings"
                            }
                        }
                    },
                    "sink": {
                        "type": "BinarySink",
                        "storeSettings": {
                            "type": "AzureBlobStorageWriteSettings"
                        }
                    },
                    "enableStaging": false
                },
                "inputs": [
                    {
                        "referenceName": "Binary2",
                        "type": "DatasetReference"
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "Binary1",
                        "type": "DatasetReference"
                    }
                ]
            }
        ],
        "annotations": []
    }
}

字符串
如果创建的视图在synapse无服务器池中，则创建与无服务器SQL池详细信息链接的Azure SQL数据库，并使用系统分配的托管身份验证，如下所述：

的
创建一个Azure SQL数据库数据集，选择此数据集的上述链接服务，然后您将能够直接选择类似表的视图。

的
这里是管道Json，用于将视图从synapse复制到blob Azure SQL数据库：

{
    "name": "Pipeline 1",
    "properties": {
        "activities": [
            {
                "name": "Copy data1",
                "type": "Copy",
                "dependsOn": [],
                "policy": {
                    "timeout": "0.12:00:00",
                    "retry": 0,
                    "retryIntervalInSeconds": 30,
                    "secureOutput": false,
                    "secureInput": false
                },
                "userProperties": [],
                "typeProperties": {
                    "source": {
                        "type": "AzureSqlSource",
                        "queryTimeout": "02:00:00",
                        "partitionOption": "None"
                    },
                    "sink": {
                        "type": "AzureSqlSink",
                        "writeBehavior": "insert",
                        "sqlWriterUseTableLock": false,
                        "tableOption": "autoCreate",
                        "disableMetricsCollection": false
                    },
                    "enableStaging": false,
                    "translator": {
                        "type": "TabularTranslator",
                        "typeConversion": true,
                        "typeConversionSettings": {
                            "allowDataTruncation": true,
                            "treatBooleanAsNumber": false
                        }
                    }
                },
                "inputs": [
                    {
                        "referenceName": "AzureSqlTable1",
                        "type": "DatasetReference"
                    }
                ],
                "outputs": [
                    {
                        "referenceName": "AzureSqlTable2",
                        "type": "DatasetReference"
                    }
                ]
            }
        ],
        "annotations": []
    }
}

型