I'm trying to import survey data from a csv file using the import wizard. I have a few columns that's about 8000 characters. From research, I went into the advanced tab of the "Choose a Data Source" screen and changed the field data types to "Text Stream [DT_TEXT].
within the column mappings screen, all of the changed fields indicate a Type of varchar and size of "max".
However, when I attempt to import, it indicates: Error: Preparation SQL Task 1: The identifier with ........ the Maximum Length is 128.
Are there any other changes/modifications I need to make? Appreciate any help.