Two BULK INSERT issues I worked around recently

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