• Luis Cazares (9/2/2015)


    Your problem was that the table didn't match the file.

    I suppose that that's what you found out (or maybe something we couldn't see).

    I suggest you to read the following article for a nice introduction on bcp/bulk insert and format files.

    http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

    Exactly, I just found out there is a mismatch and that caused this hassle, there is still issue in the bcp after I corrected the mistake, I will start a new post soon. Thank you for your understanding and I am so embarrassed when realized I made a mistake.