I've nested 23 separate BCP commands into a single BAT file. Each BCP command pulls data from a separate text file and inserts the data into a single table. Here's the kicker, when inspecting the newly inserted rows in the table, I need to be able to associate each row with the BCP command that inserted it. Modifying the source data in the text files is not possible. Is there some way to tell the BCP command to insert a constant into an additional column in the table. Note that I AM using a format.xml file with the BCP insert. If needed, I'm willing to switch from BCP to BULK INSERT. Suggestions?
September 2, 2008 5:43 PM
September 12, 2008 3:24 PM