April 28, 2003 at 9:43 pm
I have an ASP page making some stored proc calls in order to generate some XML documents (using ADO in vbscript).
My feeling is that this could be generated faster if I could generate the files from within a DTS package (since there is support with ActiveX scripting). My question is however, can you run multiple instances of the same DTS package on SQL 2000, without conflicts of any sort. There would be table updates, but mostly reading data.
thanks for any help.
May 1, 2003 at 8:00 am
This was removed by the editor as SPAM
May 2, 2003 at 5:34 pm
If I remember correctly, DTS is not used dynamically due to being slower than the alternative (SQL stored procedure, XML call). Keep in mind, too, that if you really want the SQL server to initiate the action that a stored procedure can run an executable or call a dll
Everett Wilson
ewilson10@yahoo.com
May 5, 2003 at 2:17 pm
Each DTS package has a version stored when its run. My guess would be no...you cannot run the same package versions on a single instance sql 2000.
May 5, 2003 at 2:52 pm
Sorry for not responding directly to the question before, but yes you can run multiple instances of a DTS package.
Quick Test:
use the DTSrun utility to generate the command line
open two instances of Query Analyzer
run the command line from xp_cmdshell in both at the same time
Everett Wilson
ewilson10@yahoo.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply