Geek Answers Handbook

How to integrate a RESTful web service in SSIS

I have a very simple RESTful web service (i.e. www.test.com/test.xml?date1=05/252010&date2=05252010)

This returns pretty simple XML. The client is interested in using this web service through SSIS and importing it into a table.

  • What is the best way to invoke a RESTful web service using SSIS - all the examples I've seen revolve around WSDL based web services?

  • How to pass parameters to a web service (current date, etc.)?

I'm just not familiar with SSIS, and it's hard for me to find good documentation on interacting with RESTful web services.

+5
source share
1 answer

, , , , - :

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/913c63b0-2761-4f84-94e1-3c2e3af29309

, :

Dim dtYest As Date = DateAdd(DateInterval.Day, -1, Now)
Dim strDate As String = dtYest.Month.ToString
strDate += "/"
strDate += dtYest.Day.ToString
strDate += "/"
strDate += dtYest.Year.ToString

Dts.Connections("HTTP Connection Manager").ConnectionString = "https://www.test.com/test.xml?begin_date="+strDate+"&end_date="+strDate

, .

+3

More articles:


All Articles