开发者

How to integrate a RESTful webservice into SSIS

I have an extremely simple RESTful webservice (i.e. www.test.com/test.xml?date1=05/252010&date2=05252010)

开发者_运维问答

That returns fairly simple XML. A client is interested in consuming this webservice via SSIS and importing it into a table.

  1. Whats the best way to call a RESTful webservice with SSIS - all of the examples I have seen revolve around WSDL based webservices?

  2. How do I pass parameters to the webservice (current date, etc.)?

I am just not that familiar with SSIS and am having trouble finding good documentation on interaction with RESTful webservices.


We ended up not using this feature, but based upon some more reading I found - found this article:

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

In addition to some sample code which did this:

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 

That's where my research ended.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜