Today I encountered a very hard to spot solution for BCP in. The file could be read using BULK INSERT, but BCP gave me at least four different error messages, which none were even close to describing the root cause.
After all was said and done, it turns out BCP need hyphens between year/month and month/day.
20200916 is acceptable with BULK INSERT but BCP chokes.
2020-09-16 is acceptable with both BULK INSERT and BCP.
