Post reply

SSIS Script Component - Cannot implicitly convert type 'string' to 'string[]'

  • March 9, 2010 at 12:34 am

    #138621

    Hi

    I'm trying to connect to a web service using the SSIS script component.

    The VB proxy for the web service was auto-generated by wsdl, Version=2.0.50727.3038.

    However the script component fails when it calls the web service class (GetReferenceToWebService) with the following error.

    Unable to generate a temporary class (result=1).

    error CS0029: Cannot implicitly convert type 'string' to 'string[]'

    at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns, XmlSerializerCompilerParameters xmlParameters, Evidence evidence)

    at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, Evidence evidence, XmlSerializerCompilerParameters parameters, Assembly assembly, Hashtable assemblies)

    at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings, Type[] types, String defaultNamespace, String location, Evidence evidence)

    at System.Xml.Serialization.XmlSerializer.GetSerializersFromCache(XmlMapping[] mappings, Type type)

    at System.Xml.Serialization.XmlSerializer.FromMappings(XmlMapping[] mappings, Type type)

    at System.Web.Services.Protocols.SoapClientType..ctor(Type type)

    at System.Web.Services.Protocols.SoapHttpClientProtocol..ctor()

    at ScriptComponent_bfc45a26c1f04beb9d150daa651a693f.ws.webService..ctor()

    at ScriptComponent_bfc45a26c1f04beb9d150daa651a693f.ScriptMain.GetReferenceToWebService()

    at ScriptComponent_bfc45a26c1f04beb9d150daa651a693f.ScriptMain.ProcessWS()

    at ScriptComponent_bfc45a26c1f04beb9d150daa651a693f.ScriptMain.Input0_ProcessInputRow(Input0Buffer inputRow)

    at ScriptComponent_bfc45a26c1f04beb9d150daa651a693f.UserComponent.Input0_ProcessInput(Input0Buffer Buffer)

    at ScriptComponent_bfc45a26c1f04beb9d150daa651a693f.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer)

    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)

    Would anyone have any suggestions as to the cause of the error or a way to debug the error

    in the script component?

    Thanks

    pYak

  • March 9, 2010 at 9:47 am

    #1130755

    I'm wondering if the string it is refering to in "error CS0029: Cannot implicitly convert type 'string' to 'string[]'" is incorrectly defined. I *think* you need to define the string as a string array instead of just a string. Also the [] leads me to believe C#, which I am less familiar with..

    CEWII

  • March 9, 2010 at 6:09 pm

    #1131075

    Hi Elliott

    Thanks for the reply.

    I believe that the generated error message is generic and does not infer a specific language type...

    so I think that it would just imply a string array in VB. My real issue is trying to determine where in the script component the error refers to ie the web service proxy, BufferWrapper, ComponentWrapper or ScriptMain. Debugging the script component in SSIS 2005 seems to be limited...and very frustrating.

    Cheers

  • March 9, 2010 at 7:23 pm

    #1131085

    I'd start with ScriptMain and yes, it is very limited.

    CEWII

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply