troubleshooting Question

How to keep data seperate in an application when there maybe more than one person at a time

Avatar of monica73174
monica73174 asked on
.NET ProgrammingMicrosoft SQL Server 2005
3 Comments1 Solution296 ViewsLast Modified:
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??
ASKER CERTIFIED SOLUTION
Sham Haque
Senior SAP CRM Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros