• jerald.wilks (5/1/2015)


    Hi,

    I am using SSIS 2008 to attempt to send data to a web service. The web service contains complex types which are not supported within Web Service Tasks. I am trying to use a script component (as a transformation) within a data flow, but I am not sure exactly how to send multiple fields. I've looked on several different blogs and youtube videos, but most of these are pulling data from a web service to place within a flat file or a sql table.

    I need to push data into the webservice (SSIS essentially is the middle man). Can someone please post an example of how to do this?

    Thanks

    Quick note, the SSIS Web Service Task is hardly worth using, suggest you try to find an alternative (commercial or codeplex)

    😎