I have a flat file .csv format that I am importing.
It is 53 columns across and when it hits column 3 it tells me that it can't process it, and everything after that column is null.
The column is the header row for the file and is a nvarchar(50) as is everything else for standardization purposes.
My error is:
Data conversion failed. The data conversion for column "Column 3" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
There is no text qualifier in this file, but I tried " anyway - no difference.
I set the error output to ignore the failure, and that is how I know everything is null after column 3.
The data rows come in just fine, but I am importing multiple files into one processing table, with possibly different headers, which is why I need the header row included with the data.
Anyone have any idea what is wrong with this thing?
I have spent 6 hours on it, and I am no closer to figuring it out.
I have asked for a new sample file to see if my test import file is corrupted somehow, but I haven't received it yet.
Thanks for all your assistance!!