The TableAdapter fills sucessfully and I can see the data in rows during debug.

The line that fails is:
bulkcopy.WriteToServer(TableAdapter)

I've updated my code to make a DataSet, and tried to pass that but it also fails.