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.
Here’s the code: ScriptTasks