General discussion

  • Creator
    Topic
  • #2180106

    HOW-TO: SCHEDULE A JOB OF EXECUTING A DTS PACKAGE FROM WITHIN VB6

    Locked

    by fsanchez ·

    Hi,
    I have recently created a VB6 application that provides a list of available DTS Packages on the SQL Server 2000 database to the user and allows them to execute the package.

    Although the function works fine, there is a need to have the task schedule to execute at a later time because when the task is executed, the control is not returned to the application until task is completed.

    I am interested in knowing if it is possible to use and/or program the execution of the DTS Package from within VB6 using the SQL Server 2000 job scheduler? If so, is there any available sample code that I can review to assist me in this challenge.

    Your comments and/or assistant is greatly appreciated.

    Regards
    Fernando (Wanna be Visual Programmer)

All Comments

Viewing 0 reply threads