Redirect command line output in SSIS script task
Here I'm going to show you how to use an SSIS script task to call an external program using the command line and redirect the output to a package object variable. For this example I'm using it to pull a list of files on AWS S3 and then copying them locally for processing.
You can see the code on:
https://www.midnightdba.com/redirect-...