I’m trying to create a EzAPI dataflow with an Excel Source but it keeps giving me a type error which I suspect has to do with the fact that I’m not sure how to create the EzExcelCM connection string. Does anyone have a sample?
I tried using the path and name of the source excel file but that didn’t work.
A type error? As in data type? It might be due to a datatype being the wrong type, such as an instance where we assume a value is 304 but instead the value is “304” with quotes, and so its a string instead of a number, and thus if you throw it into a math formula, it will complain about the logic falacy of adding words together instead of numbers.