How to consume a Webservice response in SSIS Script Task
Hello everyone! I apologize in advance, I am new to SOAP UI. I was tasked with grabbing data from a web service using SOAP UI and creating a C# Script and SSIS to load the data. The problem is, never having used SOAP UI before (or for that matter, using SSIS with data sources that are not databases or excel/flat files).
I am able to create the SOAP project and am able to view the data through SOAP UI, but that's as far as I've gone. Can anyone possibly direct me to some great resources that can help me out with this project? I'm not looking for someone to solve my answer for me, I just want to understand what I'm working with better so I can get this working and also be able to work on other projects in the future if needed.
Thanks in advance!
Marcel