Hi there,

I had issue similar to bulk inserts and followed one of the method in the following article.

Check this out and it might shed you some light.

http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/

thanks, M.