Hi, All!
     I have an application that builds a BULK INSERT package dynamically. It is working fine. However, I would like to add a unique value to each record that is bulk inserted that is NOT part of the input file. As a matter of fact, before the BULK INSERT, a record is written to a FilesReceived table and assigned a FileID. I want all records that are successfully inserted to have this FileID. I thought about adding and Execute SQL Task and updating all records that have a NULL FileID, but can't since this is going to be a multi-thread application and there could be records in the same staging table with NULL FileID fields that are NOT from the same file. Any clue how I can add this field DURING the BULK INSERT? Thanks.

Cheers!~


Monty D. Grimmett

OK, All. The answer is NO, you can not insert additional fields using the BULK INSERT.

However, you CAN use the OPENROWSET(BULK...) functionality to do this. This can be done within an application or within a Package either way.

Cheers~

Monty D. Grimmett