When trying to use bulk insert to insert a text file I seem to be getting a problem, because all lines are not the same length. It seems to be scipping every second one, because it is not encountering the end of the row when expected. Even when limmiting the XML format file to stop before it reaches the end of line, it still overflows into the next line.

Have u specify row terminator and field terminator while inserting data using
bulk insert from text file? Check it.

Yes, I used rowterminator, but I can't use field terminator, because the textfile is not delimited in any way. I know exactly where each field starts and end. That is why I use a XML format file. The problem is that not every line has the last 8 characters filled.