在ADF复制向导中获取文件名 [英] Fetching the name of the file in ADF copy wizard

问题描述

专家您好，

我必须将一个平面文件从Blob复制到SQL数据仓库.在复制过程中，我还必须生成文件名，并将其保存在目标表中.那怎么可能?我们是否有任何保存文件名的变量(例如slicestart，windowstart)?

I have to copy one flat file from Blob to SQL datawarehouse. I have to ge the filename as well during the copy and save it in the destination table. How is that possible? Do we have any variable (like slicestart,windowstart) which holds the filename?

预先感谢

Nikesh

推荐答案

您可以使用GetMetadata活动列出所有文件，并将其与foreach和copy活动链接，然后可以在查询中写入fileName.

you can use GetMetadata activity to list all files, and link it with a foreach and copy activity, then you can write the fileName in the query.

请参阅此文档:https://docs.microsoft.com/zh-cn/azure/data-factory/control-flow-get-metadata-activity

refer this doc: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-get-metadata-activity

这篇关于在ADF复制向导中获取文件名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！