Re: Kick off job on-the-fly

> And this relates to VB how?

euhhhhh well if his font end is written in another language as VB this
should not have a relation to VB :-)

to answer your question :

You can call DTS packages from stored procedures ,,,, ( if we are talking
bot about MS SQL Server )

so write a stored procedure that calls the DTS ,

Now the VB part :-)

from VB call the stored procedure ( prefered in a asynchronous or fire and
forget way )

regards

Michel Posseth [MCP]


"MikeD" <nobody@xxxxxxxxxxx> wrote in message
news:uDefih96FHA.3660@xxxxxxxxxxxxxxxxxxxxxxx
>
> "Test Test" <farooqhs_2000@xxxxxxxxx> wrote in message
> news:Ol5UrS86FHA.3276@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello!
>>
>> I have a scheduled job that executes a DTS package. The job is scheduled
>> to run at midnight everyday. This process is working fine. We want users
>> to be able to run this process at real time. What it means that we are
>> providing an option in the front-end tool saying "run this process now".
>> If the users choose this option (we'll store this information in some
>> table), we want the job (which executes a package) to be kicked off. Is
>> that possible to run )or control) a job (or DTS package) through some db
>> field? Please let me know. Any help would be appreciated.
>
> And this relates to VB how?
>
> --
> Mike
> Microsoft MVP Visual Basic
>
>


.

Relevant Pages

  • RE: Problem using GLobal Variables in DTS Package
    ... > I have created a DTS package, the data source is a stored procedure with an ... > The source connection for the transformation uses Microsoft OLE DB Provider ...
    (microsoft.public.sqlserver.dts)
  • Re: Kick off job on-the-fly
    ... > I have a scheduled job that executes a DTS package. ... > to run at midnight everyday. ... we want the job (which executes a package) to be kicked off. ...
    (microsoft.public.vb.general.discussion)
  • Kick off job on-the-fly
    ... I have a scheduled job that executes a DTS package. ... to run at midnight everyday. ...
    (microsoft.public.vb.general.discussion)
  • Problem using GLobal Variables in DTS Package
    ... I use SQL 2K on a Win2K box ... I have created a DTS package, the data source is a stored procedure with an ...
    (microsoft.public.sqlserver.dts)
  • Re: Output Parameter To Global Variable (DTS)
    ... DECLARE @OutputTest1 int, @OutputTest2 int ... I am executing a stored procedure with 2 input> parameters and 2 output parameters. ... > The output params are causing me a headache. ... When I execute the DTS task, only the first output param from the> stored procedure is populated into the global variable in the DTS package. ...
    (microsoft.public.sqlserver.dts)