Disponibilidad de Servidor en SSIS SQL Server 2005

Revisa el comandeo "SC"

DESCRIPTION:
SC is a command line program used for communicating with the
NT Service Controller and services.
USAGE:
sc <server> [command] [service name] <option1> <option2>...

The option <server> has the form "\\ServerName"
Further help on commands can be obtained by typing: "sc [command]"
Commands:
query--Queries the status for a service, or
enumerates the status for types of services.
queryexQueries the extended status for a service, or
enumerates the status for types of services.
start--Starts a service.
pause--Sends a PAUSE control request to a service.
interrogate--Sends an INTERROGATE control request to a service.
continue--Sends a CONTINUE control request to a service.
stopSends a STOP request to a service.
config-Changes the configuration of a service
(persistant).
description--Changes the description of a service.
failureChanges the actions taken by a service upon
failure.
qc--Queries the configuration information for a
service.
qdescription-Queries the description for a service.
qfailure--Queries the actions taken by a service upon
failure.
delete-Deletes a service (from the registry).
create-Creates a service. (adds it to the registry).
controlSends a control to a service.
sdshow-Displays a service's security descriptor.
sdset--Sets a service's security descriptor.
GetDisplayName--Gets the DisplayName for a service.
GetKeyNameGets the ServiceKeyName for a service.
EnumDependEnumerates Service Dependencies.

The following commands don't require a service name:
sc <server> <command> <option>
boot(ok | bad) Indicates whether the last boot should
be saved as the last-known-good boot configuration
LockLocks the Service Database
QueryLock-Queries the LockStatus for the SCManager Database
EXAMPLE:
sc start MyService



Saludos


Ing. Jose Mariano Alvarez
http://blog.josemarianoalvarez.com/
Microsoft MVP
SQLTotal Consulting

(Cambia los ceros por O y saca lo que sobra)

Este mensaje se proporciona tal como es, SIN GARANTIAS de ninguna clase. Por
favor tratar de indicar la versión de SQL y Service Pack. La inclusión de
(CREATE, INSERTS, etc.) para poder reproducir el problema también ayuda.










"Jose Luis Cocha" wrote in message
news:

Alguien por aquí sabe como se puede verificar la existencia de un servidor
o su disponibilidad ( Que se encuentre apagado o prendido ) a fin de poder
manejar una excepción en la aplicación?.

Saludos

José Luis Cocha
Especialista TI
Lima Perú