Calling Windows service from ACTIVEX script in DTS Package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » Calling Windows service from ACTIVEX script...

Calling Windows service from ACTIVEX script in DTS Package

Rate Topic

Display Mode

Topic Options

Author

Message

balaji_rcs

Posted Tuesday, January 08, 2008 2:41 AM

SSC 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

Gogula G. Aryalingam

Posted Tuesday, January 08, 2008 3:07 AM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 3:18 AM
Points: 780, Visits: 464

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

Post #439950

balaji_rcs

Posted Wednesday, January 09, 2008 4:14 AM

SSC 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

dharti

Posted Wednesday, January 09, 2008 9:13 AM

Forum 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 »

Permissions