SSIS Webservice Task

Question

Hi If webservice returns No value(return type is Array of Event) am getting an error SSIS Package calling websrvice task and output assigning to xmlfile.If the value is there ,No error,only when no value,then package fails. how to handle webservice task when it fails

Answer 1

We created the dll to consume the webservice and converted the array[] complex type into flat datatable to return. Now even if the return data is null no error because the flat table,previously we have the arra[] complex type with return null values breaks.