Arrays in WebService SSIS 2008

Question

So I have a Web Service that works just fine when I enter the parameter values myself.  I get results and can parse it out, storing the results into a table.  I even have it working in a "For Each Loop" for one of my variables.   The issue I have is that the Web Service accepts 3 variables, the first being an Array.   How can I populate the array variable for web service?  If it requires a script, can I get an example to a link to one?  I'm not very familiar with scripts.

---

Werner

Answer 1

Map it to the Object type of the SSIS variable and then shred it.

---

Arthur My Blog

Answer 2

I've never tried it, but the first thing I would suggest is to create an object variable and then create/load the array via a script task.  Then see if you can pass the object variable in for the Array param.

If that does not work, then it is relatively easy to use a webservice in a script task if you first create the proxy classes in a Visual studio project and then copy the resulting code into a script task. 

Here's an example

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/01/28/consuming-web-services-in-ssis-script-task.aspx

---

Chuck

Answer 3

you can create an object variable as arthur said, and fill the object variable with an Array in Script task with a simple script like this:

public void Main()
        {
            System.Collections.ArrayList arr = new System.Collections.ArrayList();
            arr.Add("the first item");
            arr.Add("the second item");
            arr.Add("the third item");
            Dts.Variables["User::Collection"].Value = arr;

            Dts.TaskResult = (int)ScriptResults.Success;
        }

---

http://www.rad.pasfu.com

Answer 4

So I've gone ahead and created a script and as a first pass, hardcoded the values to test the passing of an array is an object.  What I've noticed and is causing an error is that the variable Input list first shows the type as and INT(). 

Click OK and Open for EDIT, review the Input list and I see that int[] has changed to int - causing a failure in the web service call.

Any ideas?

---

Werner