I have a feeling I already know the answer to this, however, I want to make sure that I've covered all the bases before I throw in the towel.

I need to load lots of hierarchical data into a database on periodic. BCP was brought up as a solution. I need to load data, get back the ID of the new record and use it to create "child" records on a related table. My experience is that BCP is a blunt force application to load...