Update load-data-to-from-excel-with-ssis.md#4682
Conversation
Under "Export long text values" the second option to create the excel file using a sql statement and columns of type LONGTEXT does NOT appear to work. Only the first option works - having at least one row with data in each column > 255 double byte characters (i.e. 512 normal ones) _already_ before writing anymore rows works. So one can only make this work with an initial, manually created, dummy row. Delete the second option - it may work for other data destinations but not for Excel.
|
@simes1 : Thanks for your contribution! The author(s) have been notified to review your proposed change. |
|
@chugugrace Could you please take a look at this recommended change to the article? Look at the files changed tab. If this is correct, could you sign off? Thank you! |
|
@chugugrace Because this is removing information that @simes1 has verified to not work, I am going to sign off on the change. If this is incorrect, please let me know and we can work on adding it back with more clarification. Thank you @simes1, and apologies for the delay! #sign-off |
|
@rothja: I'm sorry - only the author of this article, @chugugrace, can sign off on your changes. But we do have an exception process - if you are on the Microsoft content or product team for this product area, you can ask the PR review team to review and merge it by sending mail to the techdocprs alias. |
6 participants
Under "Export long text values" the second option to create the excel file using a sql statement and columns of type LONGTEXT does NOT appear to work. Only the first option works - having at least one row with data in each column > 255 double byte characters (i.e. 512 normal ones) already before writing anymore rows works. So one can only make this work with an initial, manually created, dummy row.
Delete the second option - it may work for other data destinations but not for Excel.