Question

  Asked: Jul 19 2008   6:06 AM GMT
  Asked by: Deepanshu


How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.


SSIS, SQL Mail, SQL Server 2005, SQL Server Integration Services

How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



In SQL Server 2005 you want to use Database mail not SQL Mail. SQL Mail is the old mail setup which uses Outlook to send the email, and works much better with Exchange than POP3. Database mail uses SMTP to send the emails.

The easiest way to send email is via the sp_send_dbmail procedure in the msdb database. This way you can pass in a large number of parameters to have it send what you need it to.

Out of the box there is no way to send an SMS message. If you cell phone has an email address you can send to that email address. Normally it's your cell phone number @ your cell provider.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Jul 20 2008  10:32AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.