Tuesday, September 14, 2010

Book List: Task 2.5 - SSIS

So, let's review:

You put in what essentially amounts to userid/password, along with some keywords, and out comes XML. SSIS's webservice component should be able to handle this no issue, right?

Turns out, it should be. Instead, what you actually get is a known issue with the error "the selected web method contains unsupported arguments"

Check out this URL to see what I mean:


So, this bummed me out. I thought "There HAS to be a way to do this!"

In searching for an answer, I also came across the MSN WSDL file, to feed into the SSIS webservice task. This was useful to prove that it wasn't just Amazon's file. You can find it here: