0

I am new to using SSIS and I am looking for a way to send messages using SMS. Is this possible to do? And if yes, is there a way to use a Web API in SSIS to send SMS messages?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Khaled Gamal
  • 1
  • 2
  • 2
    Not sure about the Web API part, but it is possible to send an SMS using SQL Server alerts: https://www.mssqltips.com/sqlservertip/2922/sql-server-alerts-with-text-messaging-from-sql-server-database-mail/ – DenStudent Aug 22 '16 at 14:48
  • If you are talking about for admin purposes sending an email to a SMS address such as the link provided by DenStudent is the easiest way to go, if you are wanting to send out mass text messages it can be done but you would have to have a script task and a message gateway capable of sending them. So if you have the latter in the form of an API you would just use a script task to interact with the API – Matt Aug 22 '16 at 16:47
  • what i got from your comment is that if i got web api for sending sms , it will be done. if it is can u provide me with example how i will use this web api in script task ? – Khaled Gamal Aug 23 '16 at 10:26

1 Answers1

0

After i did more search i found this Question and his first answer was what i want.

the second part of my Question was about api to use i found this 2 api

  1. Nexmo
  2. Infobip but you will have to contact them first

both of them will give you atest account to use it at first , but i used the first one from SQL SSIS.

Community
  • 1
  • 1
Khaled Gamal
  • 1
  • 2