I'm using SS2000. Is it possible to send a message to a cell phone if a
package fails?

Thanks,

Dan

You could certainly send an e-mail if your gsm or another provider has an
e-mail to SMS gateway.

Alternatively there are SDK's for SMS sending and I'm sure some of them have
COM interfaces (which you can use in DTS).

Have a look here for starters:
http://www.componentsource.com/Catal...WIRELC& sc=CS

(Watch for broken link)



"Dan" <ddonahue (AT) archermalmo (DOT) com> wrote

Microsoft also has Notification Services for SQL Server 2000. I was hoping
for a simpler solution but maybe there isn't one.

Thanks Ben

"Ben" <anonymous (AT) example (DOT) com> wrote

There is an easier way. You should be able to send an email to your phone. If that's the case, create this ActiveX script in your package

Function Main(

set con = createobject("ADODB.Connection"
con.ConnectionString = "Provider=SQLOLEDB.1;Data source='"& DTSGlobalVariables("hostserver").Value &"' ;Initial Catalog=master;Integrated Security=SSPI
con.Ope

dim sq
sql = "EXEC master.dbo.xp_sendmail @recipients = 'yourname (AT) domain (DOT) com', @message = 'error text', @subject = 'error'

set cmd = createobject("ADODB.Command"
cmd.ActiveConnection = co
cmd.CommandType=
cmd.CommandText = sq
cmd.Execute

Main = DTSTaskExecResult_Succes
End Functio

I think that's all you need. There may be a bug in here - I pulled it from a more complex script that we use - but this should get you going.

In article <OTrZnBPOEHA.2524 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Dan says...
Have you looked at PageGate http://www.notepage.net/pagegate.htm ? I'm pretty
sure it will work for you.

Frank K.