Performing a Bulk Copy Operation in a Transaction 

http://msdn.microsoft.com/en-us/library/tchktcdk%28v=vs.80%29.aspx

 

http://www.4guysfromrolla.com/articles/111109-1.aspx