I am using an SSIS package to upload some CSV data to my SQL table.
Here is the error:
Attached is the table structure (I have numbered the columns so you can see which column 97 is). See file "SQL-Table-Design.ODS".
Attached is the CSV file that contains the data that is failing: See file "CSV_data.csv".
The datatype of EVERY single field in the table is set to VARCHAR(MAX) - I understand this is bad database design but I just wanted a 'catch all' structure.
Any help or advice is appreciated.