Slower performance in ActiveXscript task

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

  • RE: A couple of R2 Impressions
    ... I agree 110% with Ross M...why why why take away my DTS that I rely and works ... component or I can't use it...it is going to be hard enough to master SQL ... have concern over the decision to dramatically reduce functionality with the ... or good business for MS – it just alienates customers. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I have used DTS for import and export. ... > The DTS Designer is easy to understand and use. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL DTS Job Status
    ... your DB and have the DTS task run an Execute SQL task to write a record to ... Another option is to set up an Operator in SQL Server and have the SQL Agent ... > some of the data that was loaded from DTS. ...
    (microsoft.public.sqlserver.dts)