Sounds as though the IMEX flag might be a concern.

However, I believe that is only for Excel files, based on some reading

I'm using the text driver (due to this file having 3million rows. Again, I know that this should be done with a BULK operation, but the 'powers to be' state they want it this way.

I've 'worked around' (did it right) with a BULK operation until I can find a solution. However no luck as of yet.

I guess if I put quotes around everything that might fix it, but also jump my file size, not to mention having to write something to add the quotes.

Thank you for any additional assistance.