How to keep data seperate in an application when there maybe more than one person at a time
I have an application that loads a spreadsheet then populates a database with the data.
The next step is running an SSIS package.
The problem I am worried about is if two users want to use the application at the same time. Each set of data needs to be treated seperately. So if I load one spread sheet and need to run the ssid and someone else loads a spreadsheet and needs to run the ssid on their own data it will not get mixed together. I hope this makes sense. Any ideas??
BEGIN TRAN MyTransaction
COMMIT TRAN MyTransaction