I am working with our Database Administrator to push data through SSIS into FMP through ODBC connection.
We are running FMS16 where the data is being pushed to.
Data is coming through fine on the number fields, but not so much on the text fields.
The first record is fine, and all the rest have issues in the text fields.
Is there anything I can tell her to help her with trying to figure out why?
One of the questions she had was what kind of text does FMP like? I didn't know the answer.