Great article.  I'm looking forward to the next sets.  What caught my notice at the bottom of the page is "Do you wish you had a mentor?"  That is where...

Does it fail on the same table/import load each time?  Since it did work without issue, the problem is probably not within SQL Server, it is probably within the data...