create table dbo.ADM_County_YTD
	(
		[Record Type Code] varchar(6),
		[Record Category Code] varchar(2),
		[Reinsurance Year] int,
		[State Code] varchar(2),
		[County Code] varchar(3),
		[County Name] char(25),
		[Last Released Date] date,
		[Deleted Date] date,
	);

	BULK insert dbo.ADM_County_YTD
	from '\\...\2015_A00440_County_YTD.txt'
	with (fieldterminator='|', rowterminator='\n',FIRSTROW = 2)

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 8 (Deleted Date).
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 53
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)"

Record Type Code|Record Category Code|Reinsurance Year|State Code|County Code|County Name|Last Released Date|Released Date|Deleted Date
A00440|01|2015|01|001|Autauga||20140403|

 Msg 4863, Level 16, State 1, Line 53
Bulk load data conversion error (truncation) for row 2, column 8 (Deleted Date).