SSIS Amazon Redshift Integration Pack
SSIS Amazon Redshift Integration Pack is your one stop solution for Redshift integration scenarios. Using simple drag and drop interface you can load millions of rows into Amazon Redshift from any on-premises data source (e.g. SQL Server, Flat files, MySQL, Oracle). Execute ad-hoc DDL, DML sql commands against Redshift database such as CREATE/ALTER table, GRANT, DROP. This pack also includes task to manage your Redshift Cluster (e.g. Automate cluster creation/deletion/resize/snapshot).
SSIS Amazon Redshift Data Transfer Task
SSIS Amazon Redshift ExecuteSQL Task
|SSIS Redshift Execute SQL Task can be used to send any sql queries to Redshift Cluster without needing ODBC driver. You can Issue various sql commands such as DROP, COPY, UNLOAD, CREATE etc.
SSIS Amazon Redshift Source
|SSIS Amazon Redshift Source Connector can be used to read data from Amazon Redshift. You can use simple Table mode or write custom SQL Query to extract desired data.
SSIS Amazon Redshift Cluster Management Task
|SSIS Amazon Redshift Cluster Management Task can be used to automate most common Redshift Cluster Management Tasks such as Create Cluster, Delete Cluster, List Cluster Properties, Create Snapshot, Delete Snapshot etc.