locked
Use file name as variable in pipeline RRS feed

  • Question

  • Hi I have to copy files from a blob folder to an Aure DB through a data pipeline.

    The file name contains the customer number.

    I would like the file name to populate a column that will become part of the output.

    So that any row in that file will be associated to that particular Customer.

    Does anyone know how to do it?

    Cheers,

    Dario.



    Sunday, May 15, 2016 10:39 AM

All replies

  • Hi Dario,

    You can solve such a problem by using a custom DotNetActivity job as your transformation step, and designating the slice to be populated as the folder containing all the customer files for that particular time slice.  In your activity you would be passed the blob path that triggered the job, so you could just loop through them all, and creating a new output data set with your new customerid column read from the name of the file.

    Monday, May 16, 2016 1:18 PM