Post reply

DTS Asynchronous operations? / Progress data sent back to calling VB procedure?

  • November 21, 2005 at 8:39 pm

    #67017

    I have a VB\VBA procedure that access my DTS package, supplies global variables, then executes it. Unfortunately, the DTS package is quite long and I don't know how to send "progress" information back to the calling procedure.

    1) Is there any way to call DTS in a VB procedure and have it run asynchronously? (i.e. the VB code continues its flow without waiting for the DTS package to finish)

    2) Is there any way to to send progress info out to external processes? My DTS process has many loops. I would like to use them to drive a "progress bar".

    Thanks ahead of time for your help!

  • November 21, 2005 at 9:20 pm

    #605127

    How does you VB\VBA procedure execute the package? Does it execute it via the object model? eg: pkg.Execute, or using the command shell using DTSRUN?

    Easiest thing I can think of would be to execute the package using the command shell, that way you don't have to wait for execution to complete. The in the package have package logging enabled so execution status gets logged to the sysdtssteplog table in msdb. Then your VB\VBA procedure can read the execution progress from that table, preferably using a stored procedure.

     

    --------------------
    Colt 45 - the original point and click interface

  • November 22, 2005 at 9:56 pm

    #605387

    My SysAdmin has the DTSRUN utility "locked down" so I am forced to use something else.

  • November 28, 2005 at 10:58 am

    #606172

    Sorry for the delay ... holidays, you know.

    I am currently using the object model. I tried a method someone showed me of using a Package2 object set to a Package object in a class so that I could use events and report back results.

    I think (not at work) I set the package, set the global variables, called LoadFromSQLServer, iterated through all steps, and executed. It kept telling me that the package already had global variables. Do I need to load the package, then change the global variables, then execute?

    Thanks!

  • November 29, 2005 at 5:26 am

    #606377

    I believe this article may be what you are looking for...

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_46xv.asp

    -Mike Gercevich

  • November 29, 2005 at 8:39 am

    #606433

    Thanks for your help! 

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply