A new user to Skyvia and struggling somewhat on my first CSV import.
My CSV has all columns encapsulated in " (commas)
CSV contains some datetimes (in this example two fields) in the format "2020-07-02 00:00:00","null"
I selected the import format on these fields to DT_DBTIMESTAMP
I am trying to do an expression on one of these fields and set another field value in the DB (also tried ISNULL)
so [End Date] == null ? "Active" : "Left"
The data types "DT_DBTIMESTAMP" and "DT_WSTR" are incompatible for binary operator "==".