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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!