locked
Need to insert date in database column in while data ingestion in flat file to table on data factory RRS feed

  • Question

  • Hello team,

    I need one technical advise on data factory.

    now i have one abc.txt file at ADLS and file have 6 column and i have one table abc with 7 column (6 column from abc.txt and one column for date ).

    i have created data factory pipeline with copy activity ,now i need date column mapping with utnow() function so i can get today date when pipeline getting triggered .

    please advise!!

    please let me know if you need any help

    Regard's

    Ravi


    Tuesday, June 19, 2018 5:16 AM

All replies

  • Well, if it is the getdate() value you would want in your 7th column for all the rows then the easiest way would be to use the lookup activity once your copy activity is completed.

    You would just need to write down an update statement which would update your 7th column with getdate()

    Hope this helps you.

     

    Bhushan Gawale | RapidCircle

    • Proposed as answer by Jason_J (Azure) Wednesday, November 7, 2018 5:32 PM
    Thursday, October 11, 2018 2:50 PM