• Add a new first step to the job to check if the table exisits and only create it if it doesn't exist yet.

    Change the command to read the trace from "SELECT * INTO ... FROM " (which creates the table) to "INSERT ... SELECT * FROM " (to use the existing table).

    Use a combinations of SQL and commandprompt to get the tracefile with the lowest sequence number. Or you could use a staging table to hold the number and increase it each time the job has run. Or use some other logic to get the name of the file...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **