SQL Server Performance Forum – Threads Archive

Multiple Instances of DTS

Can we have multiple instances of DTS running?
We have a scenario where more than one client can invoke a DTS pkg at the same time.
What happens in this situation?

---

u can do this, provided u r not creating/droping any permanent temp table inside DTS for data manupulation. Madhu

---

also check this link http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=334089

---

]]>