DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Issue with DTS and ActiveX task

  1. #1
    Join Date
    Mar 2005

    Issue with DTS and ActiveX task


    This one is a mystery to me.

    I have a DTS package which consists of one ActiveX task . This task just opens a connection, goes through a loop and in that loop a stored procedure is called and the result is streamed to a file which is saved to disk.

    This all works fine and well. My problem is that this task currently takes 9minutes. However if I open up SQL Query Analyser and point to the database which the ActiveX task references this task takes 12.5 seconds.

    What am I missing here. The funny thing is if I open up SQL Query analyser and point to the database the ActiveX task references (I don't run any queries whatsover) and then immediately CLOSE SQL query analyser and then run the package it still takes only 12.5 seconds.

    If close SQL enterprise altogether, re-open it and then run the package (without opening SQL query analyser) the task takes 9 minutes. How can I get the task to take 12.5 seconds without having to open SQL query analyser.

    Just a point: I have now created a win process task which loads up SQL Query analyser and points to the database and set the timeout on this task to 20seconds. This way I can simulate opening SQL query analyser and the ActiveX task is quick but it is by no means an elegant solution.

  2. #2
    Join Date
    Mar 2005
    My first thought is caching, but it would be helpful if you posted the code your using in both the activex script and the sql script.

  3. #3
    Join Date
    Jan 2004
    Alexandria, VA
    I'm guessing there's some kind of a timeout issue, where the program is waiting for something for 9 minutes, finally times out, then continues. I can't imagine what that would be, however. It might be worth looking into your settings to see if any of them are defaulting to (or set to) ~9 minutes.
    Bob Rouse
    Dimension Data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center