SSIS Amazon Redshift Cluster Management Task

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.

  • Automate Amazon Redshift Cluster Create Action in few clicks. You can also add Access Security Rule.
  • Automate Amazon Redshift Cluster Delete Action
  • Fetch Amazon Redshift Cluster Property to SSIS Variable (e.g. Fetch Cluster Status)
  • Fetch all cluster and their properties as DataTable (Use ForEach Loop and iterate through all clusters)
  • Automate Redshift Cluster Snapshot Creation
  • Automate Redshift Cluster Snapshot Delete Action
  • Support for Wait until Cluster operation is done
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
  • Articles/Tutorials: Amazon Redshift related articles
Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements
SSIS Amazon Redshift Cluster Management Task - Create Redshift Cluster, Delete Redshift Cluster, Loop through Redshift Cluster Properties, Create Sanpshot, Delete Snapshot
SSIS Amazon Redshift Cluster Management Task – Create Redshift Cluster, Delete Redshift Cluster, Loop through Redshift Cluster Properties, Create Sanpshot, Delete Snapshot

 

SSIS Amazon Redshift Cluster Management Task - Create Cluster Option
SSIS Amazon Redshift Cluster Management Task – Create Cluster Options

 

SSIS Amazon Redshift Cluster Management Task - Create Cluster Wait Options
SSIS Amazon Redshift Cluster Management Task – Create Cluster Wait Options

 

SSIS Amazon Redshift Cluster Management Task - Create Cluster Option
SSIS Amazon Redshift Cluster Management Task – Delete Cluster Options

 

SSIS Amazon Redshift Cluster Management Task - Create Cluster Option
SSIS Amazon Redshift Cluster Management Task – Fetch Attribute Options (Single Attribute)

 

SSIS Amazon Redshift Cluster Management Task - Create Snapshot Options
SSIS Amazon Redshift Cluster Management Task – Create Snapshot Options

 

SSIS Amazon Redshift Cluster Management Task - Delete Snapshot Options
SSIS Amazon Redshift Cluster Management Task – Delete Snapshot Options

Articles/Posts

Amazon Redshift

MySQL to Redshift Data Load Using SSIS

Contents1 Introduction – MySQL to Redshift Load2 Video Tutorial3 Right way but hard way3.1 Steps for Amazon Redshift Data Load from On-Premise files or RDBMS (e.g. MySQL, SQL Server)4 Doing it easy way4.1 Should I use SSIS to load Redshift Database?4.2 Command line approach for MySQL to Redshift data loading5 Setup your Amazon Redshift Cluster6 […]

1 comment
Amazon Redshift

SQL Server to Redshift Data Load Using SSIS

Contents1 Introduction – SQL Server to Redshift Load2 Video Tutorial – Redshift Data Load3 Right way but hard way3.1 Steps for Amazon Redshift Data Load from On-Premise files or RDBMS (e.g. MySQL, SQL Server)4 Doing it easy way4.1 Should I use SSIS to load Redshift4.2 Command line approach for SQL Server to Redshift data load5 […]

1 comment

References

See Also

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This