Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calling Windows service from ACTIVEX script in DTS Package Expand / Collapse
Author
Message
Posted Tuesday, January 8, 2008 2:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 9:23 AM
Points: 30, Visits: 93
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.
Post #439937
Posted Tuesday, January 8, 2008 3:07 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:32 AM
Points: 780, Visits: 493
Try using the Execute Process Task component instead of the ActiveX script task.
Post #439950
Posted Wednesday, January 9, 2008 4:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 9:23 AM
Points: 30, Visits: 93
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
Post #440521
Posted Wednesday, January 9, 2008 9:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 28, 2011 1:55 PM
Points: 9, Visits: 47
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.

:)
Post #440752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse