SQLTeam.com | Weblogs | Forums

SQL Import Wizard; character limit

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.

I would go with your basic unicode DT_STRING and check out the setting for the destination table