Apologies all, I am brand new to SSIS, and am a bit stuck.
I have the need to be able to select 1 or more zipped files (file selection box should allow for multiple files to be selected) from the local machine, send the files to a web service, and to store the response from the web service to a local file.
While SSIS is being used for this task, there is no database interaction. It may seem strange to use SSIS in this way.
Initially, I have a script task which allows to select a single file, and I have a web service task to connect to the service, but I don't see a way to send a file between the tasks. Is that possible?
And I don't know how to capture the response to a file
I'd be grateful for any advice.