Transaction With SqlBulkCopy and SqlStatement OR Map a Specific Value using SQLBulkCopy
Posted on 2007-08-08
I need to do one of two things:
1) Map a specific value to a field in my DB using sqlBulkCopy (ie 1 = FieldName)
2) Create a transaction which will effectively lock my table while I bulk copy data into my db, then update those records with a known guid that i created in my .NET code. I need that guid to keep things straight between a file name, the field in the DB belonging to that file and a bunch of other things I won't go into.
Code Needed Please!!!