D
dwight0
I have a DTS package that can be execute from ASP.net and I was
wondering if there is a way to make this thread safe some how. I know
thread safe isn't exactly the word I'm looking for but let me know
what the correct term is. What I have is an asp.net page that executes
a DTS package and I want to be sure no two people will click a submit
button on this page from 2 different computers at the same time. And if
they do I want one to be locked until the other person's request is
done processing or at least notify the user to try again. I would
prefer to find a way to notify the person and do this in ASP.net
because I have some other pages that need to be done this way with
plain SQL update queries that aren't DTS;(I do use transactions and
locking) but I was wondering if I can just find out of another person
is on the same page, or if its processing that page from another
instance of Iexplorer. If this isn't possible, a way to prevent this
in the DTS package would work almost as well. Any ideas are
appreciated, Thanks!
wondering if there is a way to make this thread safe some how. I know
thread safe isn't exactly the word I'm looking for but let me know
what the correct term is. What I have is an asp.net page that executes
a DTS package and I want to be sure no two people will click a submit
button on this page from 2 different computers at the same time. And if
they do I want one to be locked until the other person's request is
done processing or at least notify the user to try again. I would
prefer to find a way to notify the person and do this in ASP.net
because I have some other pages that need to be done this way with
plain SQL update queries that aren't DTS;(I do use transactions and
locking) but I was wondering if I can just find out of another person
is on the same page, or if its processing that page from another
instance of Iexplorer. If this isn't possible, a way to prevent this
in the DTS package would work almost as well. Any ideas are
appreciated, Thanks!