Proxy Class is fine when used in C# project but returns error when Used with SSIS
My proxy class returns web service responses well if I use it in a C# code.
I compile it with CSC and put it in GAC to use it with SSIS.
Then I get web service response with some field values populated with "Exception of type :{System.InvalidOperationException "' occured.
Here is the part of web service response received by the C# program:
| Name | Value | Type | |
| mainAddress | {Address} | Address | |
| city | Metuchen | string | |
| cityField | Metuchen | string | |
| country | USA | Country | |
| countryField | USA | Country | |
| state | NEW_JERSEY | State | |
| stateField | NEW_JERSEY | State | |
Here is the same object returned by compiled dll used in SSIS:
| mainAddress | {BrokerConnectServiceV1.Address} | BrokerConnectServiceV1.Address | ||
| city | Metuchen | String | ||
| country | {System.Nullable(Of BrokerConnectServiceV1.Country)} | System.Nullable(Of BrokerConnectServiceV1.Country) | ||
| HasValue | FALSE | Boolean | ||
| Value | Exception of type: '{System.InvalidOperationException}' occurred. | BrokerConnectServiceV1.Country | ||
| Data | {System.Collections.ListDictionaryInternal} | |||
| HelpLink | Nothing | |||
| InnerException | Nothing | |||
| Message | Nullable object must have a value. | |||
| Source | mscorlib | |||
| StackTrace | at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) at System.Nullable`1.get_Value() | |||
| TargetSite | {System.Reflection.RuntimeMethodInfo} | |||
| state | {System.Nullable(Of BrokerConnectServiceV1.State)} | System.Nullable(Of BrokerConnectServiceV1.State) | ||
| HasValue | FALSE | Boolean | ||
| Value | Exception of type: '{System.InvalidOperationException}' occurred. | BrokerConnectServiceV1.State | ||
Below is another posting by my associate on the same issue :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=536615&SiteID=1
Any help is appreciated....

