IMPORTING CSV FILE USING BCP OR BULK INSERT
Posted on 2005-03-11
I have been trying to successfully import a | delimited file into a SQL database with no success. I continue receiving an error message about non-whitespace characters.
I read about using DTS to strip out the non-white characters by using the TRIM function. I am not a programmer - learning, however - and am asking for assistance in completing a DTS package that will strip out all of the non-whitespace characters so I can successfully conduct an import from this file.
I am not sure what information to provide so please let me know what you will need to provide a solution.