I have a two part question I hope someone could assist me with.
I have multiple .txt files I am loading into a SQL table, there is no indicator within the data as to which file is which (ex. file1, file2, etc.). The first file went through perfectly but the second had an error but still loaded some lines. I know the line count of the first file, so the question is can I delete all the rows that come after the last line of the first file or does the new data from the second file just get mixed in with the existing data?
To avoid this in the future, is there a way to add a column to the text file that indicates which file it is (for example adding File# column at the end)? That way I can delete rows that are in specific file number if I need to. Unfortunately the files are too big for me to open to add the column manually
Thanks in advance