Connect to a Web Service through Sql

Question

Connect to a Web Service through Sql

Sarah Wagner

Hall of Fame

Points: 3178
More actions
December 3, 2009 at 3:01 pm

#98348

Is there a way to connect to a web service through sql server without java or asp? I have been researching end points but it looks like that just exposes sql server as a web service. I want to push data to an existing web service weekly.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736445 More actions · Answer 1

Do you mean have SQL Server connect to a web service, not a client connect to SQL Server hosting a web service, correct?

There is a task in SSIS that can do this.

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 2

Yes this is what I want to do. Thanks for your help!!

GSquared SSC Guru Points: 260824 More actions · Answer 3

You can also do it through CLR procedures.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 4

Any ideas if something similar can be done using DTS?

Steve Jones - SSC Editor SSC Guru Points: 736445 More actions · Answer 5

Are you using SQL 2000? You posted this in 2005, so I wanted to be sure. You could potentially do this in DTS, but it would have to be completely scripted, or built using a custom task.

A few URLs:

http://msdn.microsoft.com/en-us/library/aa936758%28SQL.80%29.aspx

http://www.sqlmag.com/Article/ArticleID/5911/sql_server_5911.html

http://www.vbdotnetheaven.com/UploadFile/fbulovic/DTScustomTask04162005025109AM/DTScustomTask.aspx

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 6

Unfortunately we have a mix of 2000 and 2005 here. We haven't moved anything to integration services yet. I was hoping to utilize some of the better 2005 enhancements, but don't want to set up 2005 SSIS just for this.