将文件名添加为数据工厂管道目标中的列 [英] Add file name as column in data factory pipeline destination

问题描述

我是DF的新手.我正在将一堆csv文件加载到表中，我想将csv文件的名称捕获为目标表中的新列.

I am new to DF. i am loading bunch of csv files into a table and i would like to capture the name of the csv file as a new column in the destination table.

有人可以帮我实现这个目标吗?预先感谢

Can someone please help how i can achieve this ? thanks in advance

推荐答案

如果目标是蔚蓝表存储，则可以将文件名放在分区键列中.否则，我认为ADF没有本地方法可以做到这一点.您可能需要自定义活动或存储过程.

If your destination is azure table storage, you could put your filename into partition key column. Otherwise, I think there is no native way to do this with ADF. You may need custom activity or stored procedure.

这篇关于将文件名添加为数据工厂管道目标中的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！