且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将多个csv文件从Blob存储复制到Azure SQL?

更新时间:2023-01-30 20:22:39

Naresh,

Hi Naresh,

现在,您需要使用 对于每个活动,要包装复制活动,该复制活动会将一个csv文件中的数据加载到sql表中.但在此之前,请使用 获取元数据活动以获取blob容器中的所有文件名,然后将这些文件名传递给For每个活动以循环复制它们.这个 doc 提供了一个从多个表复制数据的示例,该示例与您的要求非常相似.希望有帮助.

Now you need to use an For each activity to wrap the copy activity, which loads data from one csv file into sql table. But before that, please use a Get Metadata activity to get all the file names in the blob container, then pass these fileNames into For each activity to loop copying them. This doc gives an example to copy data from multiple tables, which is quite similar with your requirement. Hope that helps.