Your assistance is needed. There is a problem that I have not been able to resolve.
Here is the situation:
- A table named "Notes" in SQL Server with a field named Text and a data type of nvarchar(max)
- The longest text in this field is approximately 5000 characters.
- I would like to transfer this field to an "Excel Destination" - an import template file.
My current situation is as follows:
As I build the flow, the "Excel Desintation Input -> External columns" are limited to DT_WSTR and 255 characters and I cannot change the datatype (it is overwritten automatically).
As soon as I paste 5000 characters into the first column of the excel-template file, they become "unicode text stream [DT_NTEXT]" as datatype (which I prefer).
Despite reading a lot about the limitation of excel of 255 characters, it does not make logical sense for me if I use the "workaround" with the "dummy record" and then it works.
Is there a way to solve this kind of problem?