If you can't verify that the data has the proper column delimiters and the proper row delimiters then you don't really have a data file, just a text file. You will need to parse it yourself to verify that validity of the data. You could just import each row into a TEXT field in SQL Server and try to parse the data yourself, but you don't know if the user put the proper row delimiter in the file before uploading it, so you may have incorrect data in this TEXT field. Your best bet would be to write a parser yourself and parse the file looking for all the propery column delimiters and row delimiters and report the errors as you find them. If you want to write your own bulk copy program, look at the IRowsetFastLoad interface if you are using OLE-DB, or if your going to program in ODBC, look at the bcp_* functions in the SQL Books Online.
