I'm still a little clear about what is happening. It sounds like you have a data file which is being parsed by a pPHPp program. The PHP program generates INSERT statements which are then passed to SQL server.

Are the falures always related to the Contact table?

Is this the failing INSERT statement?

INSERT INTO Contact (LongText05) VALUES ('Consumery Loansy')

In SSMS right-click on the table where the inserts are failing and choose script table as CREATE TO new queury window.

Let us see this output which will be the table structure.