Thanks for the replies.

OK, yes i am only inserting a couple thousand rows at a time so BULK INSERT is overkill?

Do i need to spend months learning SSIS to set...