I have a txt file, trying to import to a SQL table. In the table ALL cols are defined as varchar(max) (ugh)
The column it fails on has data type DT_STR (in the Data Flow task)
Things I tried:
- I set the ValidateExternalMetadata property to False - no go
- I changed col 63 to DT_TEXT - still failed
: Data conversion failed. The data conversion for column "Column 63" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
Any ideas, please? Thanks