Within Redshift - issue the COPY command, to pull the data from S3 into a Redshift table
Optionally, issue another S3 command and move the files into an "Archive" folder - for better house keeping.
To achieve these 4 steps could be time consuming to automate.
This is where ZappySys comes in to help streamline this process, and cut out hours of development.
"ZappySys is a USA based software development company.
We specialize in Data integration, Business Intelligence,
Cloud computing and .Net Application Development."
In a nut-shell - ZappySys have developed SSIS task addon's that perform many different tasks - the one that's important for this import into Redshift is the Redshift Data Transfer task.
This is equivalent to the SSIS Data Flow Task (DFT), but makes the whole process of connecting to the AWS account, Redshift cluster / database, using S3 as a flatfile staging environment a piece of cake.
Zappy even have recorded a straight-forward video on how to use this task to speed up the implementation.
Here's some more details (from http://zappysys.com/ to help summaries what they have to offer) Why SSIS PowerPack?
Coding free, drag and drop high performance suite of Custom SSIS Components and SSIS Tasks