Tip : Make your SQL Server database changes backward compatible when dropping a column

See two BULK INSERT issues I came across and how I dealt with them.

Tip : Make your SQL Server database changes backward compatible when adding a new column