I haven't had to call a web service from an SSIS package, but did call a package from a web service once that I blogged about, and today ran across a cool blog that outlines this. Pretty slick!  This one is nice because he shows the subtleties of calling a particular type of web service, one that is created from WCF (.svc, not a .asmx service, the old kind).  Remember that WCF is the framework that devs use to allow clients or consumers to hit all types of data sources via a service-oriented architecture.  There are a ton of things on this, just do a Google! search and go create one!

Check out this post, I think you'll like it as I did.  Good job!

Lee

 

-----------------------

I'm going to pay you today for this coming week... so you have some walking-around money. You need to buy some toothpaste and cleaning up supplies to have back there. Get you some magazines and some hard candy... something to keep you busy at night.

 

 

Link: http://en.wikipedia.org/wiki/Windows_Communication_Foundation


Posted in: SQL Server 2008 , .Net  Tags:
blog comments powered by Disqus

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?



Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog