The SQL Loader connector reads and writes data from flat file data, which uses a delimiter character to index the information. The flat file can be either a text file (.txt) or a CSV file (.csv).
How can this connector have a constraint of a maximum of 19 characters for any given field. This to me makes this (otherwise very useful) connector useless.
Hi @RedBaron. I looked into this limitation, and unfortunately it seems that there are limitations with the driver that the connector uses which sets this character-count limit.
You might consider posting your feedback in our Ideas Portal. As features are improved, we’ll be sure to update our documentation to reflect those changes.
You can also check out the ISC Discussions and Questions for more help from the community. Someone may have found a workaround in cases when a higher character count is required.