Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Global variables and concurrent executions

Author  Topic 

heze
Posting Yak Master

192 Posts

Posted - 2006-10-06 : 14:10:04
Hi

If I declare a global variable in a DTS package and two users execute the same package at a given time,
will thre exist two copies of the variables? (one for each user)?
is it possible at all for 2 users to execute the same package concurrently?

than you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-10-06 : 14:40:50
Global variables are only available within the one DTS package and are not viewable to other users.

Yes you can execute a DTS package concurrently.

Tara Kizer
Go to Top of Page
   

- Advertisement -