I have a table that i'm using a bulk insert to add records to. my problem is that one of the columns in this table is Quantity. from this # i need to insert that many rows in another table using some of the values bulk inserted into table1. i was trying to use a trigger to do this, but i'm not sure how.
A good general strategy to follow is to avoiding loading bulk data, throuch BCP, DTS, or anything else, directly into production tables.
Load the data into a staging table first, and then use a stored procedure to process that data and move it into the productiont tables. Before the process completes it should delete all the succesfully loaded staging records. Anything left over in the staging table at completion can help you find bugs in your process.
If it's not practically useful, then it's practically useless.