Results 1 to 4 of 4

Thread: Dtsrun

  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Exclamation Unanswered: Dtsrun

    I run DTS run from the VB6 using SHELL, when i run each time new process is invoking and previous process is not closing. bcz. of this lot of memory is taking and my system is hanging. pls. help me how to resolve this.
    Thank You all
    D. Shyam Benagal
    dsb@inspira.com
    Inspira Technologies

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245

    Re: Dtsrun

    A bit more information would be helpful:

    1. Is the VB6 app running on the same machine as the SQL Server? or is it a different client?

    2. Have you considered using SQL Agent to schedule and run the DTS package?

    3. Does the prior instance of the DTS package actually terminate and finish its actions? or is it still running when the next instance pops up?

    Also pls include some information regarding what the DTS package is doing, what tables/procs it references.

    Regards,

    Hugh Scott

    Originally posted by SHYAM
    I run DTS run from the VB6 using SHELL, when i run each time new process is invoking and previous process is not closing. bcz. of this lot of memory is taking and my system is hanging. pls. help me how to resolve this.
    Thank You all
    D. Shyam Benagal
    dsb@inspira.com
    Inspira Technologies

  3. #3
    Join Date
    Dec 2002
    Posts
    2

    Re: Dtsrun

    Thank's for u r reply Hugh Scott. That problem is rectified (some memory leak in the Pakage)

    rgds
    shyam

    Originally posted by hmscott

    A bit more information would be helpful:

    1. Is the VB6 app running on the same machine as the SQL Server? or is it a different client?

    2. Have you considered using SQL Agent to schedule and run the DTS package?

    3. Does the prior instance of the DTS package actually terminate and finish its actions? or is it still running when the next instance pops up?

    Also pls include some information regarding what the DTS package is doing, what tables/procs it references.

    Regards,

    Hugh Scott

  4. #4
    Join Date
    Aug 2002
    Posts
    6

    Post dtsrun

    what's the sql server version?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •