Good day, A few weeks back I posted to send sms from Agent preferably or SSIS when job fails. I then found out i require an sms service, the company is about to purchse some software (Grapevine). The Grapevine software sends sms using XML File/Code, how would i execute/use the XML File code in Agent/SSIS to send the sms. example of xml: <?xml version="1.0" encoding="UTF-8" ?><gviRequestResult><resultCode>0</resultCode><resultText>{url encoded name value pairs} Messages accepted for delivery</resultText></gviRequestResult> Basically 2 questions: 1. How would like to do this in Agent - perhaps agent to call SSIS pkg to send sms 2. How do i use the xml code? Thank You in Helping

SSIS can't execute XML?

SSIS can't execute XML? XML is not executable. It is a document you can send to application for processing. I suspect you are referring to this company product. It looks like you have to post an XML document to a specific URL. You can do this by implementing a script, which uploads your SMS XML over the HTTP protocol. You can check this script for reference how to do the upload.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Thank You very much, this is the company. Unfortunately i cant test until we have the software, will test script once got software. I needed to know if it was possible before purchasing the software. Thank You - Regards