dbTalk Databases Forums  

Different Users running the ame DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Different Users running the ame DTS package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ScanPlus
 
Posts: n/a

Default Different Users running the ame DTS package - 08-28-2004 , 04:13 AM






Hi All:
I have a DTS package with a global variable.
I was wondering what would happen if two different users run (VB.NET) the
package at the same time and each sets the value of the Global Variable to a
different value.

Regards,
Saeed


Reply With Quote
  #2  
Old   
Nigel Rivett
 
Posts: n/a

Default RE: Different Users running the ame DTS package - 08-28-2004 , 12:53 PM






They will have different copies of the variables.
A copy of the package is loaded before it is run so even if the users are on
the same m/c (dts is a client app so runs on the client m/c) they will have
different versions.

"ScanPlus" wrote:

Quote:
Hi All:
I have a DTS package with a global variable.
I was wondering what would happen if two different users run (VB.NET) the
package at the same time and each sets the value of the Global Variable to a
different value.

Regards,
Saeed


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.