Forum Discussion

SnoekL's avatar
SnoekL
Icon for Helper II rankHelper II
2 years ago
Solved

DataFlow Gen2 issue We couldn't convert to Date.

I'm loading data from a on-premise Gupta database using ODBC with DataFlow Gen2 It's working fine until I try to make it an incremental refresh using the last date from the already loaded table.   ...
dataflow
  • SnoekL's avatar
    SnoekL
    2 years ago

    The VW_INCR_DATE value is coming from the warehouse and is the last date for which the data is already loaded. That is not from the source.

  • SnoekL's avatar
    SnoekL
    2 years ago

    I found the solution. The query which extracts the Date value from the warehouse should have "enable staging" false to get it working. Not sure why though :).

SnoekL's avatar
SnoekL
Icon for Helper II rankHelper II
2 years ago

I found the solution. The query which extracts the Date value from the warehouse should have "enable staging" false to get it working. Not sure why though :).

  • Cosmic_Panda's avatar
    Cosmic_Panda
    Frequent Visitor
    2 years ago

    Thanks a lot.

     

    It was really giving me a hard time. Can't believe it was simply turning off "Enable Staging".