When exporting from a SQL database to Excel in SSIS, I have a problem in a column in SQL that is VARCHAR(1000) , I tried to pass it to Unicode_Ntext , but I get the error:
[Excel Destination [84]] Error: An error occurred while setting up a binding for the "observation" column. The binding status was "DT_NTEXT".
Unfortunately when the columns that will receive the data are created in the destination excel, the first 8 rows are taken into account, if none of those 8 records exceeds 255 characters for the column in question, it will be left with a maximum of 255 for the rest of the table. This is an EXCEL bug that can only be solved in a couple of ways:
As a suggestion: I remember that there was a way to modify in the windows registry the number of rows used to assign the type and length to the columns, but I never did. I'd like to search in google.