CREATE TABLE Member
(MemberID BigInt Identity(10001,1) Primary Key Not Null,
Fname Char(20) Not Null,
Lname Char(20) Not Null,
DOB Datetime Not Null,
Street Char(30) Not Null,
Suburb Char(20) Not Null,
State Char(3) Not Null,
Pcode Char(4) Not Null,
Phone Char(12),
Mobile Char(11),
DLicNo Char(6 ),
JoinDate Datetime Not Null,
AccBalance Dec(6,2) Not Null,
ValidMember Int Not Null,
Passwd Char(6 ) Not Null,
Constraint CC_ValidMember CHECK (ValidMember IN ('0', '1', '2')))
GO

"MemberID","Fname","Lname","DOB","Street","Suburb","State","Pcode","Phone","Mobile","DLicNo","JoinDate","AccBalance","ValidMember","Passwd"
100001,"John","News",7/6/1970 0:00:00,"123 Oak St.","Sydney","NSW",2000,"(02)97451165","0413-111111","91231C",1/5/1997 0:00:00,0,1,"aaaaaa"
100002,"David","Senior",8/1/1940 0:00:00,"18 Belmorw St.","Bankstown","NSW",2115,"(02)97411325",,"45231C",1/5/1997 0:00:00,0,1,"aaaaab"
100003,"Ann","Parsons",12/3/1981 0:00:00,"24 Surf St.","Manly","NSW",2095,"(02)99415356",,"57129C",14/6/1997 0:00:00,0,1,"penguin"

USE Megavideos
GO
BULK INSERT Megavideos.dbo.Member
FROM 'C:\Database\Member.txt'
With
(
firstrow = 2,
fieldterminator = ','
)

Server: Msg 4863, Level 16, State 1, Line 1
Bulk insert data conversion error (truncation) for row 12, column 7 (State).
Server: Msg 4865, Level 16, State 1, Line 1
Could not bulk insert because the maximum number of errors (10) was exceeded.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
The statement has been terminated.

Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 4, column 12 (JoinDate).
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 5, column 12 (JoinDate).
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 9, column 12 (JoinDate).