• Lowell (2/7/2014)


    David, where would you put the data reference to the file? is there an additional column at the end of the table, that you can use to update right after the BCP;

    for example, if the destination table has 15 columns, and bcp inserts into the first 14 columns, afterwards you could call sqlcmd to update the destination table where col15 is null;

    so you'd have to add a sqlcmd line for each file processed to your script file.

    Now that I read my initial post, I realised I could have been much clearer. In any case, you worked out what I meant. Thanks!