Solved

Call a web service from Sql Server 2012 stored Procedure

Posted on 2014-04-23
1
1,595 Views
Last Modified: 2016-02-10
I have few stored Procedures which run some query and based on the result send mail to clients.

Now my client has added a web service in his company which sends mail to customers.

He wants me to use this service inside the store procedure and send mail through this web service.

I need to know what would be the best option for me here to call this service for sending emails.
Should I go for SQL CLR and UDF?
0
Comment
Question by:yadavdep
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

by:
ProjectChampion earned 265 total points
ID: 40019452
You can use an SSIS package, use a script task to call the URL and get the response back and use it within your store proc.

Let me know, I can help with the actual script if you decide to go down that path.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql update 2 36
Can I skip a node in XML? 9 32
Finding Where Clause Value in SQL Views and SP 21 36
UPDATE JOIN multiple tables 5 19
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question