SQL BULK INSERT Format Issues

Question: I'm using SQL Server and Management Studio. I was getting data conversion errors when performing a BULK INSERT into a table, that I could not resolve and switching to using a format file allowed data to be inserted, but the data inserted wa...