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.

35 pts.
Tags:
SQL
SQL Server 2005
SQL Server Integration Services
SSIS
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,130 pointsBadges:
    report
  • Deepanshu
    [...] Get the answer to this question: How can I send mail through an SSIS job? [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following