Post reply

Calling Windows service from ACTIVEX script in DTS Package

  • January 8, 2008 at 2:41 am

    #185256

    hi,

    I've created a windows service and i want to execute the windows service from DTS package in sql server. Is it possible to execute the service from DTS package server. Can you please guide me to resolve this.

  • January 8, 2008 at 3:07 am

    #765633

    Try using the Execute Process Task component instead of the ActiveX script task.

  • January 9, 2008 at 4:14 am

    #766085

    hi,

    Thanks for reply in. I used this task, but i dont know abt how to call the windows service , i refered the exe file of the windows service in the task, but it throws the error and it says that "It cannot start from the tool, call by using administrative tools".

    Please help me to call the windows service from DTS package and once the service is completed, i want to move to the next step

  • January 9, 2008 at 9:13 am

    #766278

    HI,

    Use Execute SQL task with master Database connection..

    use command

    xp_cmdshell 'NET START TELNET'

    (Service name you have to find from

    the control pannel. if you need to run your own service make sure

    you have registered that service.)

    xp_cmdshell 'NET STOP TELNET'

    and this way u can even run the package as job it will work succesfully.

    🙂

Viewing 4 posts - 1 through 3 (of 3 total)

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