Re: Slower performance in ActiveXscript task


yinthomas@xxxxxxxxx wrote:
I implement an ActiveXscript task in a DTS package for looping several
store procedures in SQL 2000. The task run normally (around half an
hour) in the past half an year. However, without any changes of the
DTS, the processing time of this task increased significantly to one
hour. After 2 days, the processing time increased to 2 hour. I would be
grateful if anyone can help for such strange case in DTS task.

.

Relevant Pages

  • Slower performance in ActiveXscript task
    ... I implement an ActiveXscript task in a DTS package for looping several ... store procedures in SQL 2000. ... the processing time increased to 2 hour. ...
    (microsoft.public.sqlserver.dts)
  • Re: Slower performance in ActiveXscript task
    ... the processing time increased to 2 hour. ... grateful if anyone can help for such strange case in DTS task. ... using CPU - ActiveX can use a lot of cpu. ... Or, did you switch from ...
    (microsoft.public.sqlserver.dts)
  • Re: Database searching via asp/vbscript
    ... > tables and different combinations of search options to dymanically ... > if there is an easier and quicker (in terms of processing time) of ... SQL, ORACLE, and MySQL. ... link tables to the real DB, then use the Access query builder to build my ...
    (microsoft.public.scripting.vbscript)
  • Re: Triggering a DTS Package
    ... SQL can't tell you when a file appears in a directory - you'd need to do ... that using other tools such as the .Net FileSystemWatcher framework class. ... DTS task either via it's COM interface, using the DTSRUN.exe utility or the ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How to import fixed-width text file in MS SQL 2000?
    ... The wizard does not have the option to use the Bulk Insert DTS task. ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.clients)