Hi,I am trying to make a call to a third-party web service in my SSIS package. The request has custom complex data type as the parameter. As has been pointed out in this forum before, the Web Service Task only lets you assign the outside parameter from a variable, not the internal parameters needed to create the complex data type. To be more specific, the web service input wants a 'ContactSearchRequest' parameter. I can assign this from a variable. If I click on the 'value' field under the 'Input' section for the web service task, it shows me that the 'ContactSearchRequest' data type is made up of the following:contactId - longnumResults - intoffset - intpassKey - stringsearchParam - stringsortType - intUnfortunately, I can't assign these internal parameters from a variable, at least not through the web service task interface.My next thought was to create a variable of type 'object' and then set it in a script task prior to calling the web service task. However, I'm not sure exactly how to do this. How will my script know about the class definition of 'ContactSearchRequest'? Do I just create a class called 'ContactSearchRequest'?I've used this same web service in a .NET C# project and after I imported the web service, visual studio knew all about the custom data types. How do I do something similar in SSIS?Of course, the easiest solution would for Integration Service to allow me to set those internal parameters via variables, but we're apparently not there yet.Any suggestions?Thanks,Trey

Probably easier to use a script task to call the web service. It's fairly simple to implement, and handling complex types is much easier.

Do you have any advice on how to go about calling a web service from a script task? Any references? Like I said, I've done it in a c# .NET project, but the visual studio that opens from the script task doesn't look like I can add a web service reference.Trey

Here's a few threads with info: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1461773&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1423720&SiteID=1

Hi All, I am trying to pull the data from a webservice. The method expects 5 parameters out of which one is a complex type. And it is fine to pass Null value for this parameter. The method expects a complex data type UrlReportFilter as follows: <simpleType name="UrlReportFilterOperatorEnum"> <restriction base="xsd:string"> <enumeration value="contains"/> <enumeration value="starts_with"/> <enumeration value="ends_with"/> <enumeration value="not_contains"/> <enumeration value="not_starts_with"/> <enumeration value="not_ends_with"/> <enumeration value="match_regular_expression"/> <enumeration value="not_match_regular_expression"/> <enumeration value="exact_match"/> </restriction> </simpleType> <complexType name="UrlReportFilter"> <sequence> <element name="caseSensitive" type="xsd:boolean"/> <element name="operand" nillable="true" type="xsd:string"/> <element name="operator" nillable="true" type="akaaimsdt:UrlReportFilterOperatorEnum"/> </sequence> </complexType> How to assign values and use this in VB.NET code? I am using following code to assign the values to the properties in VB.NET code in Script task but it is throwing the error below: Dim vUrlFilter As New Akamine.UrlReportFilter With {.caseSensitive = False, .operand = ""} Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Web.Services.Protocols.SoapException: AWSFault:Error in processing:(com..aws.services.exceptions.InvalidColumnException: Invalid column: for report:H Any help on this would be appreciated!! Thanks, Ruby Thanks & Regards

Hi Jwelch, Can you please explain an example for this? Thanks, RubyThanks & Regards