After I pasted the errors began. I looked back at my data in my .csv and found no reason that all the records should not commit. Not sure how to use the LEN function in this case although I'm familiar with it "SELECT LEN(Address) as LengthOfAddress FROM Persons". I'd would be looking at the data that commited rather than the one's that failed (?). I also have access only to SSMS in SQL Server Express so my options are limited.