Invalid date format in ADF

rajanisqldev-42 201 Reputation points

Hi All,

I need to import data from ADLS to SQL in incremental mode.

I have a config table in SQL and querying this table to get LASTMODIFIEDON using Lookup activity

The datatype in config table is in datetime.
Next step in pipeline is For each loop
In the for each container, I have Dataflow activity.
I have assigned the value @item().lastmodifiedon to dataflow variable defined as timestamp.
I am getting error "parse error in dataflow", if I remove the above assignment, pipeline succeeding.

What am I doing wrong here?


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,056 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 26,896 Reputation points Microsoft Employee

    Hi @rajanisqldev-42 ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your query.

    For better clarification, could you please confirm if the parameter you created in the dataflow is of date datatype or string datatype. I would recommend you to keep the parameter as string datatype and use toDate() function within dataflow to convert it to date datatype further. Also, while passing the variable to dataflow inside dataflow parameter tab, check the expression checkbox.

    Please let us know if it helps. Thankyou